Peter Jacobi wrote:
Will the upgrade to MySQL 5 give us (within the limits
of Wikipedia per
language) culture correct sorting or just the default Unicode collation?
MySQL has several language-specific Unicode collations in addition to
the generic one:
Czech
Danish
Estonian
Icelandic
Latvian
Lithuanian
Persian
Polish
Roman
Romanian
Slovak
Slovenian
Spanish
Swedish
Turkish
Note that "Language-specific collations for the utf8 character set are
implemented only if the ordering with utf8_unicode_ci does not work well
for a language. For example, utf8_unicode_ci works fine for German and
French, so there is no need to create special utf8 collations for these
two languages."
For the full list and notes see:
http://dev.mysql.com/doc/refman/5.0/en/charset-unicode-sets.html
-- brion vibber (brion @
pobox.com)