Re: Wrong sorting order in croat.conf (spouse all version)

   Hello!

Sinisa Milivojevic wrote:
> Dubravko Penezic writes:
> 
>>Hi !
>>
>>No that are not case, I use MySQL version 4 and 3, all data are stored
>>like ISO-8859-2 strictly, for more info please look on next URL :
>>
>>http://www.laus.hr/sistem/char-sets/grafem.html
>>http://www.open.hr/hiz/kodsus/primjena.html
>>
>>and all my database and table use croat definition.
>>
>>What you sed is complitly wrong becouse Ss in win-1250 is on position 9A
>>and 8A and in ISO-8859-2 is on position B9 and A9.

Yes, I agree. The the above pages state this too.
And this is what I wrote in my previous letter
to Sinisa:

> latin2:
> 
> 0xA9    0x0160  #LATIN CAPITAL LETTER S WITH CARON
> 0xB9    0x0161  #LATIN SMALL LETTER S WITH CARON
> 
> cp1250:
> 
> 0x8A    0x0160  #LATIN CAPITAL LETTER S WITH CARON
> 0x9A    0x0161  #LATIN SMALL LETTER S WITH CARON

I'm 100% sure abote these three facts:

1. "croat" was created for cp1250 character set,
and it provides correct sort order for Croatian
language for cp1250.

2. "croat" was renamed into "latin2_croatian_ci" in mistake
in 4.1, it should have been "cp1250_croatian_ci" instead.

3. We didn't have Croatian sort order for latin2 character
set in MySQL so far, and it should be just added now.


Your version could be used as a template for latin2 Croatian,
but for my opinion, the patch fixes only a half of the problem,
and an additional fix is required: to put CAPITAL LETTER Z WITH CARON
on the same position with SMALL LETTER Z WITH CARON. Now they
are sorted differently.

Please confirm this. Or am I mistaken?
Please send the complete table for testing in this case.

Thank you.

>>Like I implement in croat.conf and send to bug report. You expert need to
>>check and reread ISO standard onece again.
>>
>>And finaly, changing that value all data is order corectly.
>>
>>it is not mistake in conversion !!!
>>
>>it is good renaming becouse more then 85% percent of all MySAL
>>implementation is on Linux/UNIX os , so name like latin2_croatian_ci is
>>O.K. in 4.1. version of MySQL.
>>
>>If still your expert are not sure what I am talking about, I will send
>>comlete table for testing.
>>
>>Dubravko Penezic
>>ISA, Srce
>>University Computing Center
>>Zagreb, Croatia
>>
> 
> 
> Hi!
> 
> This goes a way beyond my charset knowledge, so I am involving the
> persons in charge. 
> 
> On an unrelated issue.
> 
> If Hrvoje Niksic is still there, please give him my regards.
> 


-- 
For technical support contracts, visit https://order.mysql.com/
    __  ___     ___ ____  __
   /  |/  /_ __/ __/ __ \/ /    Mr. Alexander Barkov <[email protected]>
  / /|_/ / // /\ \/ /_/ / /__   MySQL AB, Full-Time Developer
/_/  /_/\_, /___/\___\_\___/   Izhevsk, Russia
        <___/   www.mysql.com   +7-912-856-80-21


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]