Bug #22028 select HEX(CONVERT('ę' using cp1250)) return bad code

• Submitted: 5 Sep 2006 18:02
• Modified: 5 Sep 2006 18:23
• Reporter: [ name withheld ]
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 5.0.24
• OS: Windows (XP)
• CPU Architecture: Any

[5 Sep 2006 18:02] [ name withheld ]

Description:
select HEX(CONVERT('ę' using cp1250));
return A9 
but 'ę' in cp1250 is EA

select HEX(CONVERT('ę' using latin2));
return A9 
but 'ę' in latin2(ISO-8859-2) is EA

How to repeat:
select HEX(CONVERT('ę' using cp1250));

[5 Sep 2006 18:23] Sveta Smirnova

Thank you for the report.

But I can not repeat it using last BK sources:

mysql> set names cp1250;
Query OK, 0 rows affected (0.00 sec)

mysql> select HEX(CONVERT('ę' using cp1250));
+--------------------------------+
| HEX(CONVERT('ę' using cp1250)) |
+--------------------------------+
| EA                             |
+--------------------------------+
1 row in set (0.00 sec)

mysql> select HEX(CONVERT('ę' using latin2));
+--------------------------------+
| HEX(CONVERT('ę' using latin2)) |
+--------------------------------+
| EA                             |
+--------------------------------+
1 row in set (0.00 sec)