MySQL Forums
Forum List  »  Backup

Trying to backup data with chinese characters
Posted by: Sally Low
Date: November 30, 2015 07:41AM

I recently took over a server running sql and I'm trying to do a periodic backup of the sql database. The database contains some fields in English and some fields with Chinese characters. When i run a "show variables like 'character_set%', this is what i get:

character_set_client | gbk
character_set_connection | gbk
character_set_database | latin1
character_set_filesystem | binary
character_set_results | gbk
character_set_server | latin1
character_set_system | utf8

When i do the mysqldump, i've tried setting --default_character_set=utf8 but when i opened the .sql file, the Chinese characters are captured in gibberish. I then re-run using --default_character_set=gbk and i still get gibberish. Can someone help guide me in how do i back up the database so that the Chinese characters are captured correctly?

Options: ReplyQuote


Subject
Views
Written By
Posted
Trying to backup data with chinese characters
2018
November 30, 2015 07:41AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.