Solution to mysql garbled characters in ubuntu

After a whole day, finally solved the problem of jdbc (mysql-connector-java-5.0.30) and mysq communication Chinese garbled! My system is linux (Ubuntu ). Use hibernate to connect to mysql in java (Myeclipse environment. There is no problem in English storage. Both insert into and select can be correctly displayed, but if they contain Chinese characters, they will be garbled. I searched for the materials online for half a day and finally succeeded.

My solution is to add the following two lines in the/etc/my. cnf file:
[Client]
Default-character-set = utf8
[Mysqld]
Default-character-set = utf8
Note that this file does not necessarily exist, you need to copy/install the original file/support-files/my-medium.cnf to/etc/, rename

Mysql needs to be restarted
Disable: sudo/usr/local/mysql/bin/mysqladmin shutdown
Enable sudo/usr/local/mysql/bin/mysqld_safe-user = mysql &

View mysql Encoding
After sudo/usr/local/mysql/bin/mysql is enabled
Mysql> show variables like 'character % ';
+ -------------------------- + ---------------------------- +
| Variable_name | Value |
+ -------------------------- + ---------------------------- +
| Character_set_client | utf8 |
| Character_set_connection | utf8 |
| Character_set_database | utf8 |
| Character_set_filesystem | binary |
| Character_set_results | utf8 |
| Character_set_server | utf8 |
| Character_set_system | utf8 |
| Character_sets_dir |/usr/share/mysql/charsets/|
+ -------------------------- + ---------------------------- +

Note: after this change, the original database does not seem to be available (uncertain) and backup as much as possible.

When you create a database, there will be no garbled characters.