Re: reply to user and bugs@ ... list

Hi!

Ukrainian win1251ukr looks really very incorrect. A
person who contributed .conf file made something wrong.
There are problems in sort order and even in to-upper and
to-lower mappings. In upcoming mysql-4.1 I introduced
new 1251 based character sets which fit to the all of
Cyrillic alphabets: Russian, Ukrainian, Belarusian,
Bulgarian, Macedonian and Serbian.

Unfortunately, I can't send you a new .conf file
because their format has been changed. But if you want
I can send you a new style file which can be easily
used to cook an old-style one. Please let me know if
you are interested.

Hope this helps.
Regards!



Sinisa Milivojevic wrote:

>
> ------------------------------------------------------------ ------------
>
> Subject:
>
> win1251ukr.conf character order bug
> From:
>
> "Yura Pylypenko"
> Date:
>
> Wed, 22 Jan 2003 19:33:06 +0200
> To:
>
>
>
>
> 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
>
>
>
> ------------------------------------------------------------ ------------
>
>
> Part 1.2
>
> Content-Description:
>
> .signature
> Content-Type:
>
> text/plain
> Content-Encoding:
>
> 7bit
>
>





------------------------------------------------------------ ---------
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-thread13568@lists.mysql.com
To unsubscribe, e-mail

Re: reply to user and bugs@ ... list

Now I understand that ukrainian language problem can not be solved with
single-byte charset, because ASCII does not contain letter "³" and "²".
Latin analogues are used (code 73 - I code 105 - i ) and changing sort order
for 73 and 105 chars will destruct latin alphabet.

> Hi!
>
> Ukrainian win1251ukr looks really very incorrect. A
> person who contributed .conf file made something wrong.
> There are problems in sort order and even in to-upper and
> to-lower mappings. In upcoming mysql-4.1 I introduced
> new 1251 based character sets which fit to the all of
> Cyrillic alphabets: Russian, Ukrainian, Belarusian,
> Bulgarian, Macedonian and Serbian.
>
> Unfortunately, I can't send you a new .conf file
> because their format has been changed. But if you want
> I can send you a new style file which can be easily
> used to cook an old-style one. Please let me know if
> you are interested.
>
> Hope this helps.
> Regards!

> > 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-thread13577@lists.mysql.com
To unsubscribe, e-mail

Re: reply to user and bugs@ ... list

Hi!

On Fri, Jan 24, 2003 at 07:19:35PM +0200, Yura Pylypenko wrote:
> Now I understand that ukrainian language problem can not be solved with
> single-byte charset, because ASCII does not contain letter "?" and "?".
> Latin analogues are used (code 73 - I code 105 - i ) and changing sort order
> for 73 and 105 chars will destruct latin alphabet.

Sorry, I do not understand what you mean?

Only cp866 do not contain Ukrainian I & i, but koi8-u and cp1251 does.

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com

------------------------------------------------------------ ---------
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-thread13578@lists.mysql.com
To unsubscribe, e-mail

Re: reply to user and bugs@ ... list

Sorry, I found out why it happened. If I use "mysql" client under windows it
runs with cp866 charset and if I try to insert letter "³" it inserts as
latin "i"
With MySqlManager (winconsole) it works as expected
> Hi!
>
> On Fri, Jan 24, 2003 at 07:19:35PM +0200, Yura Pylypenko wrote:
> > Now I understand that ukrainian language problem can not be solved with
> > single-byte charset, because ASCII does not contain letter "?" and "?".
> > Latin analogues are used (code 73 - I code 105 - i ) and changing sort
order
> > for 73 and 105 chars will destruct latin alphabet.
>
> Sorry, I do not understand what you mean?
>
> Only cp866 do not contain Ukrainian I & i, but koi8-u and cp1251 does.


------------------------------------------------------------ ---------
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-thread13583@lists.mysql.com
To unsubscribe, e-mail

Re: reply to user and bugs@ ... list

Hi!

On Sat, Jan 25, 2003 at 12:22:01PM +0200, Yura Pylypenko wrote:
> Sorry, I found out why it happened. If I use "mysql" client under windows it
> runs with cp866 charset and if I try to insert letter "?" it inserts as
> latin "i"

I am not used windows for long time but as I remember it use cp866 for
console application to be compatible with DOS.

> With MySqlManager (winconsole) it works as expected

But it use cp1251 for GUI.

[skip]

--
For technical support contracts, visit https://order.mysql.com/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Oleksandr Byelkin
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Lugansk, Ukraine
<___/ www.mysql.com

------------------------------------------------------------ ---------
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-thread13589@lists.mysql.com
To unsubscribe, e-mail