场景如下
1.查询后获得乱码数据
2.无法插入中文数据
mysql> INSERT INTO STUDENT(s_id,s_name,s_birth,s_gender) VALUES ('03','孙风','1990-01-03','男');
ERROR 1366 (HY000): Incorrect string value: '\xCB\xEF\xB7\xE7' for column 's_name' at row 1
解决办法
SHOW VARIABLES LIKE '%char%';
将character_set_client 和 character_set_results 修改为gbk即可
set character_set_client=gbk;set character_set_results=gbk;