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

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/

croat.conf
win1250.conf

what you talking about is win1250 in some case called cp1250

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


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