Mysql Drump Code for Chinese problem fixed

Today, I got into the issue with the drump code in Chinese.

The issue is that can not display Chinese characters.

Tried many solutions that suggested from other web side. i.e. update the character set in database level, add default-character-set=utf8 in my.cnf file.

All this can not fix the issue.

but lucky, I checked the columns setting before reinstalling mysql.

The issue final determined on the column char settings.

bcz, I am new to MySql, when I create the database, I used default setting. and then when I created tables columns with default setting as well, which means all varchar columns are in Latin1 character set. so this is the real problem.

After I updated the db default character set and updated every varchar column to utf8, and update the data again with Chinese as well, all goes well.

Chinese can be displayed perfectly.