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

   Hello!


Dubravko Penezic wrote:
> Hi !
> 
>>>>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.
> 
> 
> Wrong ... check in repository of codepage you have in source dir
> ./sql/share/charsets/

Did you try croat.conf on a Windows machine?
Did it produce wrong Croatian sort order?

> croat.conf
> win1250.conf
> 
> what you talking about is win1250 in some case called cp1250

Yes, it is fine for Croatin too (and for some other languages).
That means we had two cp1250+Croatian compatible
configurations, and didn't have a single one for latin2+Croatian.

I'm attaching a new sort order array for latin2+Croatian
configuration. Can you please replace the old one by this
new array, and test if sort order is fine.

There is also HTML file attached, it demonstrates the
sort order in a clear manner.

Thank you!

> Croatian languge have only one code page standard which is recommandate by
> law, and that is ISO Latin 2 under ISO code 8859-2.
> 
> CP1250 or win1250 or what ever Micro$oft would like ta call thay
> "standard", is only forced standard, but situation is radical changed in
> last 5 years.
>
> Also freely check linux/unix implementation of croatian character, you
> will finde only latin2 under ISO-8859-2 code shema.
> 
> Also very simply test of ordering will show you that croat.conf sort under
> ISO-8859-2 code page except wrong Ss position, inserting character whit
> code of win1250/cp1250 will destroy that oreder.
> 
> 
>>2. "croat" was renamed into "latin2_croatian_ci" in mistake
>>in 4.1, it should have been "cp1250_croatian_ci" instead.
> 
> 
> once again wrong, see above.
> 
> 
>>3. We didn't have Croatian sort order for latin2 character
>>set in MySQL so far, and it should be just added now.
> 
> 
> Partialy thrue, you have,but with wrong Ss position :)
> 
> 
>>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.
> 
> 
> I will check tomorow morning what I can do with other part, maybe I will
> need some help about meaning of other part of table.
> 
> 
>>Please confirm this. Or am I mistaken?
>>Please send the complete table for testing in this case.
> 
> 
> I will send tomorow table for testing.
> 
> Thank You too, I understand that people outside Croatia, and many inside
> dont understand what is going on, and also government do nothing to
> make order in code page standard.
> 
> Dubravko Penezic
> 
> P.S.: Also I will try to make some test table for testing order and
> lower/upper case.
> P.S.S.: We use one table which may help to understanding code page whic
> are in use in Croatia.
> http://www.open.hr/hiz/kodsus/primjena.html
> 


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

 00 01 02 03 04 05 06 07 08 09 0A 0B 0C 0D 0E 0F
 10 11 12 13 14 15 16 17 18 19 1A 1B 1C 1D 1E 1F
 20 21 22 23 24 25 26 27 28 29 2A 2B 2C 2D 2E 2F
 30 31 32 33 34 35 36 37 38 39 3A 3B 3C 3D 3E 3F
 40 41 4C 4E 56 5C 66 68 6A 6C 72 74 76 7E 80 86
 90 92 94 9A A3 A9 B3 B5 B7 B9 BD C5 C6 C7 C8 C9
 CA 41 4C 4E 56 5C 66 68 6A 6C 72 74 76 7E 80 86
 90 92 94 9A A3 A9 B3 B5 B7 B9 BD CB CC CD CE CF
 D0 D1 D2 D3 D4 D5 D6 D7 D8 D9 DA DB DC DD DE DF
 E0 E1 E2 E3 E4 E5 E6 E7 E8 E9 EA EB EC ED EE EF
 F0 41 F1 76 F2 76 9A F3 F4 9C 9A A3 BD F5 BF BD
 F6 41 F7 76 F8 76 9A F9 FA 9C 9A A3 BD FB BF BD
 94 41 41 41 41 76 52 4E 50 5C 5C 5C 5C 6C 6C 56
 58 80 80 86 86 86 86 FC 94 A9 A9 A9 A9 B9 A3 9A
 94 41 41 41 41 76 52 4E 50 5C 5C 5C 5C 6C 6C 56
 58 80 80 86 86 86 86 FD 94 A9 A9 A9 A9 B9 A3 FE