Bug #6028 | chinese character display wrong | ||
---|---|---|---|
Submitted: | 11 Oct 2004 13:25 | Modified: | 19 Oct 2004 1:18 |
Reporter: | wang sysc | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | Connector / J | Severity: | S2 (Serious) |
Version: | 3.1.4-beta | OS: | Windows (win XP SP2) |
Assigned to: | CPU Architecture: | Any |
[11 Oct 2004 13:25]
wang sysc
[11 Oct 2004 13:54]
wang sysc
the same thing in 3.1.4-beta
[18 Oct 2004 20:09]
Mark Matthews
Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.mysql.com/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to 'Open'. Thank you for your interest in MySQL.
[19 Oct 2004 0:16]
wang sysc
my encoding is chinese 'big5'. and I insert chinese data in connector/J 2.0,when I upgrate connector/J and mysql the chinese word display wrong. maybe it's the reason about chiese encoding method change. when I use connector/J 3.0 to insert data, and use mysql CC to check the data ,it displays '無名' and the word is right, but my old data is '無名氏' this is correct in mysqlcc. and if I use connector/J 3.0 to query the data, the first one display wrong in mysql CC become the right character,the second one(many of my old data like this)become unreadable character.
[19 Oct 2004 0:18]
wang sysc
in this page can't display that word :( anyway,the old version is still work for me.
[19 Oct 2004 1:18]
Mark Matthews
Is your MySQL server actually configured to use Big5 as an encoding? If you're using MySQL-4.1, are the tables and/or columns themselves configured to use Big5? If so, how (can you post the output of 'SHOW CREATE TABLE'). How are you configuring the JDBC driver to use the Big5 encoding?
[19 Oct 2004 8:18]
wang sysc
I use MySQL 4.0.21-win. the encoding is latin1(maybe this is the problem?) , in the previous vision (3.x) this is work for chinese character.The installer did not tell me to choose character encoding. I try to upgrate MySQL to 4.1, I use 4.1 installer vision, when I nearly finish setup, MySQL tell me could not start service ERROR:0.(I uninstall the previous mysql then install 4.1 and I have already researt my machine.)
[19 Oct 2004 9:38]
wang sysc
<%@ page contentType="text/html; charset=Big5"%> DriverManager.getConnection("jdbc:mysql:///database1?user=root&password=??"); use this is work in 2.0 connector/J with 3.x mysql tomcat 4.0.x