(Brion Vibber <brion(a)pobox.com>)m>):
At some point in the near future I'll be adding in a per-language sort
order adjustment, so that various sorted lists should turn out in more
or less correct order for a change. :)
I'd appreciate pointers to descriptions of various languages' sorting
requirements so I can try to get them right.
Collation rules for all languages are defined in the Unicode spec;
I believe MySQL contains many of them, but I'm not sure how to tell
it how to use them. It's often a lot more complex than doing a few
character substitutions, even for some fairly common languages (for
example, Spanish requires some 2-to-1 subs, German a 1-to-2, and
French uses accents only when necessary).
--
Lee Daniel Crocker <lee(a)piclab.com> <http://www.piclab.com/lee/>
"All inventions or works of authorship original to me, herein and past,
are placed irrevocably in the public domain, and may be used or modified
for any purpose, without permission, attribution, or notification."--LDC