Thread

Mr. Kim—In my case the database is not so large: Hundreds (low hundreds, at that) of entries instead of thousands. Reeorder solved the issue for me, after struggling with a custom field designed to do a numeric sort.

Kim Ryu Hyun, this doesn’t affect all non-Latin users, typically only multibyte character sets, and even then you’d be surprised how few sites order by title/custom field.  This issue comes up once or twice a year at most.  The default communication of the underlying architecture that ExpressionEngine is built on (PHP and MySQL) are at fault here, and there’s not a simple change we can make to 1.x to make this work for you without impacting thousands of other users in a way that they may not wish.  That is why we’re reserving that change for 2.0, as moving to the new version is a voluntary decision, and we’ll be forcing all sites on that version to use utf-8.

There are workarounds that will allow you to essentially implement this on your installation without having to use Reeorder, but we are not going to force that change on all of our existing 1.x users.  The hack should not affect you should you decide to upgrade to 2.0 when it is released, and on the off chance that it does, we would help you get around that obstacle.  There are a few users of Cyrillic-based languages that have also implemented this hack, and we intend to help them migrate to 2.0 as well.

I see.

Derek, with your assurance, I am proceeding to finding a work-around solution for my project. What I am trying to build is a 20k+ titles audio book library with related chapter information entries. Authors, translators, narrators are also related entries, the reason I need good sorting from EE. I have mixed English and Korean titles in the library. It would be good if I could become one of your beta testers for 2.0 beta release.

Please keep me posted. Thanks.

No problem, Kim Ryu Hyun; sounds like an ambitious project, definitely submit it to use for Showcase inclusion when you’re finished.  Keep an eye on the EE Blog for information regarding Phase 2 of the 2.0 Beta, and when you apply, reference this thread, please.

I wouldn’t mind a peek at the Phase 2 beta for the same reason—Unicode sort of content would make my life easier.

Let’s just hope that EE can handle the load that I am going to put it through. If it does then definitely will submit it to use for Showcase inclusion when I am done.

Thanks.

Kim Ryu Hyun,

I am gonna close this one out for now. Feel free to start a new thread if you have any other questions