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

[10 May 2012 1:53] lin ling
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
[26 Jul 2012 20:31] Sveta Smirnova
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.
[14 Aug 2013 15:46] Chuck Bell
Fixed in release-1.2.4
[27 Sep 2013 5:22] Philip Olson
Fixed.

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