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:
None 
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
Description:
the chinese character display wrong , when I use mysql 4.x + connector/J3.0

in the past, I use connector/J 2.0 + mysql 3.x , the chinese character display correctly, when I update mysql and connector /J , all character is wrong.

when I use MySQL CC to connect the mysql and check the data, the data display correctly, and then I use MySQL browser to check the data , all data wrong, all chinese become unreadable character.

How to repeat:
use mysql 3.x with connector J2.0 +tomcat 5.0
then insert chinese character into database with varchar or text type with JSP

all data display correctly 

update the connector J to 3.0 the database will become unable to connect

update the mysql from 3.x to 4.0 the database will able to connect again and all chinese character display wrong.

I am sure my character type encoding is right chinese-Big5.

Suggested fix:
maybe check the 2.0 connector/J and find what is wrong?
[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 '無名&#27' 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