MySQL Bugs: #6386: Doesn't support Chinese

Bug #6386	Doesn't support Chinese
Submitted:	2 Nov 2004 14:45	Modified:	30 Nov 2004 22:03
Reporter:	Juliau Gong	Email Updates:
Status:	Closed	Impact on me:	None
Category:	Connector / NET	Severity:	S3 (Non-critical)
Version:	1.0.2 gamma	OS:	Windows (WinXP Pro SP2)
Assigned to:	Reggie Burnett	CPU Architecture:	Any

Description:
can't display Chinese correctly.

How to repeat:
if the result has Chinese, it can't be displayed correctly.

Can you give me more details?  What version of MySQL are you using?  What character set are you running on the server?  What is the output of SHOW CREATE TABLE on the table that you are inserting data into?

I am using MySQL Server 4.1.7, the server's default character set is latin1, but I have tried set it to utf-8, then all record in the database is uncorrect.

the table is:

CREATE TABLE `adsl` (
  `custid` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
  `custname` VARCHAR(45) NOT NULL,
  PRIMARY KEY(`custid`)
)
TYPE = InnoDB;

thanks.

tested with the latest version, the bug is still here.

Perhaps, it must be added the properties like JDBC URL, such as useUnicode and characterEncodeing.

I think this will help to solve the problem.

Here is some code that works for me with Chinese.

MySqlConnection c = new MySqlConnection( myconnstr + ";charset=utf8" );
c.Open();

execSQL("DROP TABLE IF EXISTS Test");
execSQL("CREATE TABLE Test (id int, name VARCHAR(200) CHAR SET big5, name2 VARCHAR(200) CHAR SET gb2312)");

MySqlCommand cmd = new MySqlCommand( "INSERT INTO Test VALUES(1, '&#22256;&#24043;&#24536;&#21542;&#24441;', '&#28061;&#25630;&#35895;&#20394;&#39757;' )", c);
cmd.ExecuteNonQuery();

cmd.CommandText = "SELECT * FROM Test";
MySqlDataReader reader = null;
try 
{
	reader = cmd.ExecuteReader();
	reader.Read();
	Assert.AreEqual( "&#22256;&#24043;&#24536;&#21542;&#24441;", reader.GetString(1) );
	Assert.AreEqual( "&#28061;&#25630;&#35895;&#20394;&#39757;", reader.GetString(2) );
}
catch (Exception ex) 
{
	Assert.Fail( ex.Message );
}
finally 
{
	if (reader != null) reader.Close();
	c.Close();
}

Thank you for taking the time to report a problem.  Unfortunately
you are not using a current version of the product your reported a
problem with -- the problem might already be fixed. Please download
a new version from http://www.mysql.com/downloads/

If you are able to reproduce the bug with one of the latest versions,
please change the version on this bug report to the version you
tested and change the status back to "Open".  Again, thank you for
your continued support of MySQL.

Additional info:

Please use the charset property on the connection string to set the character to be used for queries.    You'll also want the table to be either the character set you want to use or utf8.

Reggie,

Thanks very much, it can display the Chinese inserted by the Connector, but it still can't display those inserted by other programs, I thinks those doesn't use utf8. but the other driver on the mysql website such as MySQLDriverCS can do that.

Will the .Net Connector can do that in the future.

when I edit the content use the MS C# control such as DataGrid, the Chinese can't saved correct, I think that is because when I input the Chinese in the DataGrid the content is not inputed as UTF8, it use the locale of my OS. So, how can I solve this problem.

I am sorry, I have make a mistake, it can be edited with the C# correctly, thanks very much.

By the way, the MySQLAdapter:Update() method doesn't Open the Connection when the Connection is Closed auto. Can you let it open the connection automatic when the connection is closed and then close the connection after it finish the updating, like the Fill() method. And the Microsoft Class does that automatic.

I found that the Connector doesn't support the CharSet gbk, but the MySQL Server supports it.

one more thing, I found that the table's Character Set doesn't affect anything about displaying Chinese.

After the modified the Charater set to other not utf8, the .Net connector can still display the Chinese inserted by the connector correctly. When I set the Connector's charset wrong, Chinese can be displayed correctly, but can't update them correctly, it will throw a exception.