Re: Wrong sorting order in croat.conf (spouse all version) - Alexander Barkov - com.mysql.lists.bugs

10 messages in com.mysql.lists.bugsRe: Wrong sorting order in croat.conf...

From	Sent On	Attachments
Dubravko Penezic	25 Mar 2004 04:35	.conf
Sinisa Milivojevic	25 Mar 2004 05:58
Sinisa Milivojevic	25 Mar 2004 07:18
Dubravko Penezic	26 Mar 2004 00:15
Sinisa Milivojevic	26 Mar 2004 05:25
Alexander Barkov	30 Mar 2004 06:06
Dubravko Penezic	30 Mar 2004 11:43
Alexander Barkov	31 Mar 2004 02:37	.txt
Alexander Barkov	31 Mar 2004 02:44
Dubravko Penezic	01 Apr 2004 02:13

Subject:	Re: Wrong sorting order in croat.conf (spouse all version)
From:	Alexander Barkov (ba...@mysql.com)
Date:	03/30/2004 06:06:05 AM
List:	com.mysql.lists.bugs

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.

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.