出错提示:[HY000][1366] Incorrect string value: '\xE5\xBC\xA0\xE4\xB8\x89' for column 'name' at row 1
原因:创建表时,字段的编码格式是非UTF-8的 ,添加中文字段信息时会报错
解决方法一:可以直接在创建表的语句后面加(适用于创建表时)
CHARACTER SET utf8 COLLATE utf8_general_cil
CREATE TABLE tb_worker( id INT PRIMARY KEY AUTO_INCREMENT, name VARCHAR(32), age INT, sex VARCHAR(8), worker_id INT UNIQUE )CHARACTER SET utf8 COLLATE utf8_general_ci; alter table tb_worker CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
解决方法二:可以利用Alter语句修改表的结构(适用于创建表之后)
alter table tb_worker CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;