MySQL Bugs: #9476: the polish national letters are treating as the same like their latin symbols

Bug #9476	the polish national letters are treating as the same like their latin symbols
Submitted:	30 Mar 2005 7:15	Modified:	24 May 2005 21:33
Reporter:	Adam Radlowski	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.0.22, 4.0.24	OS:	Linux (Linux RedHat 9.0,k.2.4.20-31.9)
Assigned to:		CPU Architecture:	Any

Description:
Tested on MySQL-standard 4.0.22, and 4.0.24:
when in /etc/my.cnf i have:
default-character-set=win1250, and I have primary key field nazwa varchar(10) I become an error:
========
mysql> select * from t5 order by nazwa;
+--------+--------+
| nazwa  | liczba |
+--------+--------+
| a      |      0 |
| b      |      0 |
| &#324;       |      0 |
| &#324;n  |      0 |
| ó      |      0 |
| ósemka |      0 |
| osiem  |      0 |
+--------+--------+
7 rows in set (0.00 sec)

mysql> insert into t5 values ('o',0);
ERROR 1062: Duplicate entry 'o' for key 1
mysql>

How to repeat:
Construct table, like in description and try (IT MUST BE: primary key field nazwa varchar(10)).
In reality table with only one record it will be enough to test it:
+--------+--------+
| nazwa  | liczba |
+--------+--------+
| ó      |      0 |
+--------+--------+
Then try:
insert into t5 values ('o',0);

Suggested fix:
"o" and "ó", "&#324;" and "n" and other polish letters are not the same - it should be corrected

is this the same problem as in bug 9604?

http://bugs.mysql.com/9604

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".