Hello Mike,
Mike Futerko wrote:
> Hello,
>
> 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.
>
> Many thanks,
> Mike.
>