Hello Alexander,
>> Not sure it's the right list, but...
>>
>> I noticed that MySQL (checked with versions 4.1.14, 5.0.16) sorts
>> Ukrainian letters in a wrong order in UTF8 charset, while other
>> Cyrillic charsets (koi8u, cp1251) works well.
>>
>> The question is: what is the right way to fix the problem?
>>
>> Should I add new collation "utf8_ukrainian_ci" like there are for
>> Polish, Swedish, Turkish etc languages or just fix some UTF8 code table?
>>
>> Note that other Cyrillic characters are sorted well, except only
>> Ukrainian.
>>
>> Any hints/help would be appreciated.
>
>
> Unfortunately that's true, Ukranian letters are not sorted well in
> utf8_general_ci. However, there is no a need to add a separate collation
> for Ukranian. Please try utf8_unicode_ci. It sorts the Ukranian letters
> correctly.
Thanks for the help, but it doesn't work for me. I did the following:
1) ALTER DATABASE ... COLLATE utf8_unicode_ci;
2) SELECT ... ORDER BY ...;
And Ukrainian letter "I" shown before "A" :(
Regards,
Mike.
