Bug #9046 Characte Set Bug

• Submitted: 8 Mar 2005 10:21
• Modified: 8 Mar 2005 17:42
• Reporter: alireza vahedi
• Status: Can't repeat
• Category: MySQL Server
• Severity: S3 (Non-critical)
• Version: 4.1.8,4.1.9,4.1.10
• OS: Windows (windows(xp,2000) - linux)
• CPU Architecture: Any

[8 Mar 2005 10:21] alireza vahedi

Description:
hi,
this is the third time that, i report my problem in mysql.
if you don't want solve my problem, please tell me.

i recently install MySQL 4.1.8 successfully.
I have created a database and one table at in.
the character set of database and table is UTF8.
I have no problem with my data, but when i enter characters with code:1601,
This code change into my table to code:1663
i enter my data from a html form on a web application.
i test mysql version 4.1.9 and 4.1.10, but my problem don't solve.

you can find detail and graphical description about this problem in address:
http://www.kimiatech.net/bug.gif

thank you

How to repeat:
hi,
this is the third time that, i report my problem in mysql.
if you don't want solve my problem, please tell me.

i recently install MySQL 4.1.8 successfully.
I have created a database and one table at in.
the character set of database and table is UTF8.
I have no problem with my data, but when i enter characters with code:1601,
This code change into my table to code:1663
i enter my data from a html form on a web application.
i test mysql version 4.1.9 and 4.1.10, but my problem don't solve.

you can find detail and graphical description about this problem in address:
http://www.kimiatech.net/bug.gif

thank you

[8 Mar 2005 17:42] Alexander Keremidarski

create table bug9046(c char(8)) character set utf8; Query OK, 0 rows affected (0.00 sec)

insert into bug9046 values(0x1601);
Query OK, 1 row affected (0.00 sec)
select hex(c) from bug9046;
+--------+
| hex(c) |
+--------+
| 1601   |
+--------+
1 row in set (0.00 sec)

Please provide repeatable test case and make sure that this is not a problem with the web application you are using. 

We can only investigate and fix the problems which occur into MySQL server, MySQL client libraries or connection between client and server provided that MySQL client librarires or some of Connectors are used.