win1251ukr.conf character order bug
am 22.01.2003 18:33:06 von Yura PylypenkoHow-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