MYSQL错误： SQL 错误 [1366] [HY000]: Incorrect string value: '\xE4\xB8\xAD\xE5\x9B\xBD' for column

错误信息：Incorrect string value: '\xE4\xB8\xAD\xE5\x9B\xBD' for column 'home_country

 

 修改表、字段字符集

# 修改表字符集
alter table user_info default character set utf8;

# 修改字段字符集
alter table user_info change home_country home_country varchar(100) character set utf8;