MySQL encoding problem

Command line operations sql The code problem

mysql> INSERT INTO t_stu VALUES(1,' Zhang San ',' male ');
ERROR 1366 (HY000): Incorrect string value: '\xD5\xC5\xC8\xFD' for column 'sname' at row 1

modify my.ini The configuration file

 In path ：C:\ProgramData\MySQL\MySQL Server 5.7\my.ini  find my.ini file 

 Modify the content 1：
	 find [mysql] command , In about 63 Row or so , Add... On the next line  
		default-character-set=utf8
 Modify the content 2:
	 find [mysqld] command , In about 76 Row or so , Add... On the next line 
		character-set-server=utf8
		collation-server=utf8_general_ci

 After modification , restart MySQL57 service 

Check the code command

show variables like 'character_%';
show variables like 'collation_%';

• If the above configuration is correct

Command line operations sql It's still messy

mysql> INSERT INTO t_stu VALUES(1,' Zhang San ',' male ');
ERROR 1366 (HY000): Incorrect string value: '\xD5\xC5\xC8\xFD' for column 'sname' at row 1

reason ： According to the configuration just now , The server thinks your client's character set is utf-8, In fact, the character set of your client is GBK.

See all character sets ：SHOW VARIABLES LIKE ‘character_set_%’;

Solution , Set the client character set of the current connection “SET NAMES GBK;”

set names gbk; It's to tell the server , The client uses GBK code , Prevent confusion code .

sometimes , That doesn't solve the problem , for example , some win10 Under the operating system environment , So modify the properties of the command line -》 Options -》 Check use old console , Then restart the computer