A solution for Mysql Chinese garbled problem in Windows environment _mysql

Recently, the development of the project to pick up the MySQL, in the construction of the environment encountered in the Chinese garbled problem. Let me share my solution with you.

1, through show VARIABLES like ' character_% '; Show all the setup items. Set the UTF8 encoding into UTF8.

Set the way such as: Set Character_set_server=utf8;

2, go to the MySQL installation directory to find My.ini files. Set inside the latin1 for UTF8

3, in addition, if the Java side of the communication data occurred when garbled words on the response.setcharacterencoding ("Utf-8");