mysql sex_关于my sql插入name ,sex,中文报错解决

mysql> insert into Friend2(numb,name,sex) values('0001','琪亚娜','女');

ERROR 1366 (HY000): Incorrect string value: '\xE7\x90\xAA\xE4\xBA\x9A...' for column 'name' at row 1

解决方案

修改mysql的字符集：

mysql> set character_set_client=utf8;

mysql> set character_set_connection=utf8;

mysql> set character_set_database=utf8;

mysql> set character_set_results=utf8;

mysql> set character_set_server=utf8;

mysql> set character_set_system=utf8;

mysql> set collation_connection=utf8;

mysql> set collation_database=utf8;

mysql> set collation_server=utf8;

修改表的字符集

alter table 表名 character set utf8;

修改字段的字符集

alter table 表名 change name name char(10) character set utf8;