MySQL Chinese appears? , set UTF8

MySQL under the Windows system:

1. Locate the MySQL profile: The file name may not be my.ini (such as My-default.ini) and modified to My.ini.

Open the configuration file and edit it as follows: (if no [client] is added)

3. Restart the MySQL server, right-click on the computer-manage--。。。。

Operate in the MySQL client (or cmd at the command line)----"The results are as follows: Latin1;

The database created later is the UTF8 format;

4. If you have already created a database and a table, the following method is used to modify it;

1. Modify the encoding of the entire database:

ALTER DATABASE name default character set UTF8 collate utf8_general_ci;

2> Modify tables (which are modified with the formatting of columns and fields in the table)

ALTER TABLE name convert to character set UTF8 collate utf8_general_ci;

At this point, the modification is complete, inserting a new data again;

MySQL Chinese appears? , set UTF8