MySQL cannot insert Chinese characters to resolve

1. Based on the maintenance of the angle, although latin1 is not a problem, but still try to switch to UTF8 or GB series

2. When garbled:

SHOW VARIABLES like ' character% '
SHOW VARIABLES like ' collation_% ';

Set character_set_xxx = UTF8

Modify the Encoding

A, to ensure that the data stored in the database and database encoding consistent, that is, the data encoding and character_set_database consistent;
b, to ensure that the character set of communications with the database character set consistent, that is character_set_client, character_set_connection and character_set_database consistent;
C, to ensure that the return of select is consistent with the coding of the program, that is, the character_set_results is consistent with the program coding;
D, to ensure that the program code and browser, terminal code consistent

3. To be simple, set each character set to a consistent, write to the MySQL configuration file, each time with the client set the character set (set names ' xxx '), write and read remember to ensure that the byte stream encoding is OK

MySQL cannot insert Chinese characters to resolve