MySQL Bugs: #65273: export database which contains Chinese Simplied characters

Bug #65273	export database which contains Chinese Simplied characters
Submitted:	10 May 2012 1:53	Modified:	27 Sep 2013 5:22
Reporter:	lin ling	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Utilities	Severity:	S2 (Serious)
Version:	5.2.39	OS:	Any (Windows Server 2003 DataCenter, Linux)
Assigned to:		CPU Architecture:	Any

Description:
export a database which contains Chinese Simplied characters changed to be irrecognizable either metadata or data.For example, I create a database whose table column has Chinese Simplied characters fields or create a database not contains a Chinese Simplied characters fields but insert a record into a table that contains Chinese Simplied characters. MySqL DEFAULT CHARSET is utf8，so when i use mysql workbench the characters can be recognizable,but when i use mysqldbexport.exe to export the metadata and data to a text file,the output text file contains irrecognizable characters to replace Chinese Simplied characters, so i can't backup my database,what can i do, it is serious,so i get you fetch help.my email is wbhqf@163.com，please contact me.

How to repeat:
1.use this sql script to create a table
CREATE DATABASE dccs;
USE dccs;
CREATE TABLE `base_comparam` (
  `comParamContent` varchar(20) NOT NULL,
  `comParamRemark` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`comParamContent`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
2.insert data which contains Chinese Simplied characters
insert into base_comparam (comParamContent,comParamRemark) values ('中国','简体中文');
insert into base_comparam (comParamContent,comParamRemark) values ('美国','英语');
insert into base_comparam (comParamContent,comParamRemark) values ('日本','日文');
3.export the database
mysqldbexport.exe --server=root:123456@localhost:3306 --export=B --bulk-insert dccs >d:\dccs.sql
4.open the dccs.sql,then you can know what i say

Thank you for the report.

Verified as described: result file does not contain character set information at all. And there is no option to specify it.

Fixed in release-1.2.4

Fixed.

        The default charset for MySQL connections is now set to "utf8"
        instead of latin1, in order to support non-latin data.