All of the following are ubuntu12.04
1. Modify the MySQL configuration file.
1.1. vi/etc/mysql/my.conf find [client] add below it
Default-character-set=utf8
1.2. Add below [mysqld]
Character-set-server=utf8
Collation-server=utf8_general_ci
Then save my.conf to restart MySQL.
Login MySQL in command input
Show CREATE TABLE TableName or show full columns from TableName
View the character set settings in a database table.
Show variables like ' char% '
View current system parameters
Reference: http://blog.csdn.net/ACMAIN_CHM/article/details/4174186
http://heavengate.blog.163.com/blog/static/2023810532013312105131655/
2. Open Navicate, click Connect, then right-click to select Connection Properties, tap Advanced, use MySQL character set this option is not ticked on. Then close it.
Solve the problem of navicate connection MySQL database Chinese garbled