MySQL Bugs: #70092: Showing Chinese characters in data in Workbench

Bug #70092	Showing Chinese characters in data in Workbench
Submitted:	20 Aug 2013 13:32	Modified:	9 Jan 2014 1:01
Reporter:	Dennis Lee	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:	6.0	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	Chinese, UTF-8, workbench

Description:
Created a table with a field named txtFirstName with char set as utf-8 and collation as utf-8_unicode_ci

This field can store English or Chinese names. Have an application to put Chinese into this field and able to retrieve and display it on screen through the application with no problem. Seems work properly. But when using WB to open the table, the field is displaying some unreadable characters.

Have tried to change the appearance by going to Edit->Preferences->Appearance and change Configure Fonts to Simplified Chinese and restart WB but still not OK.

Attached is the table dump.

How to repeat:
1. Open the table
2. Go to ID 159 and look at the field txtFirstName
3. The data is incorrectly displayed
4. Expect to see 鄧 in the field txtFirstName
5. Expect to see 冠珠 in the field txtLastName

table dump

Attachment: employeeDump.sql (text/plain), 26.74 KiB.

Can you attach a screenshot?

SQL Chinese Char screenshot

Attachment: SQL Chinese Char.png (image/png, text), 86.16 KiB.

Screen shot attached

It looks like your dump is bad or your data is stored incorrectly. Look for info about double-encoding of UTF8 characters

You can see the data data is invalid by opening your dump file in a UTF-8 aware text editor.