MySQL5.5 the default encoding settings to modify the method detailed

Look up the information on the Internet, set the default code on the line. Set the method to open the My.ini. Generally in the MySQL installation directory, but Xampp MySQL seems to be in the installation directory under the bin directory.

Add under [client]

The code is as follows	Copy Code
Default-character-set=utf8,

Add under [mysqld]

The code is as follows	Copy Code
Character_set_server=utf8;

or add under [MySQL]

The code is as follows	Copy Code
Default-character-set=utf8,

Restart the MySQL service

The code is as follows	Copy Code
Service MySQL Start

At this point, complete the Modify default encoding, login MySQL and then reuse show variable like '%character% '

This allows you to set the default encoding for MySQL to UTF8.