MySQL Bugs: #2906: Wrong Polish character order

Bug #2906	Wrong Polish character order
Submitted:	20 Feb 2004 10:24	Modified:	18 Mar 2004 22:48
Reporter:	Janusz Popielewski	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0, 4.1	OS:	Windows (Windows XP)
Assigned to:	Alexander Barkov	CPU Architecture:	Any

Description:
Wrong Polish character set sort order in win1250.conf and cp1250.xml.
Polish characters are not always properly sorted:

eg. ¥ is before A, should be after A and so on

Wrongly sorted characters:

¥¹, Êê, £³, Ññ, Óó

Properly sorted characters:

Ææ, Œœ, ?Ÿ, ¯¿

Proper sort of Polish alphabet (small letters example):

a ¹ b c æ d e ê f g h i j k l ³ m n ñ o ó p q r s œ t u v w x y z Ÿ ¿

How to repeat:
Try to use default-character-set=win1250 and add some data to your table
with Polish characters. The sort order will be wrong.

Suggested fix:
Changes in win1250.conf for version 4.0.x and cp1250.xml for version 4.1.x

We will look at fixing this in 4.0;  Shifting all characters in 4.0 is likely to cause more problems than it will solve.

Sorry, but the bug system is not the appropriate forum for asking
support questions. Your problem is not the result of a bug.
For a list of more appropriate places to ask for help using MySQL
products, please visit http://www.mysql.com/support/

Thank you for your interest in MySQL.

Additional info:

cp1250 is used not only by Polish language, but
also at least by these languages:
Albanian, Bosnian, Croatian, Czech,
German, Hungarian, Polish, Romanian(limited),
Slovak, Slovene, Sorbian-Lower, Sorbian-Upper

Changing the sort order may break other languages.
What we can do is to create a new collation for
Polish language. So this is not a bug, but a
feature request. I added this task into our 
TODO system.