Re: UTF8 Ukrainian collation

[Alexander Barkov]

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.
>