win1251ukr.conf character order bug

win1251ukr.conf character order bug

am 22.01.2003 18:33:06 von Yura Pylypenko

How-To-Repeat:
1. Run mysqld with --default-character-set=win1251ukr
2. Create new table and fill it with ukrainian (cyrillic) characters "³" and
"à"
3. do SELECT * FROM table ORDER by letter_field

You will get an output: "³" "à" rather than proper order "à" "³"
This happens because ukrainian charset win1251ukr.conf has bug with
characters alphabetic order.
Letter "i" is the first letter though it should be 12th.
There is no an alternative cyrillic charset with support of ukrainian.

Here is proper ukrainian alphabet
àáâã´äåºæç賿éêëìíîïðñòóôõö÷øùüþÿ

Here is win1251ukr order
³ àáâ´äåºæçè¿éêëìíîïðñòóôõö÷øùüþÿ


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread13553@lists.mysql.com
To unsubscribe, e-mail