INSERT INTO garbage.type ( id, type,type_sub) VALUES
( 1, “纸类”,“属于可回收物” ) Error Code: 1366. Incorrect string value: ‘\xE7\xBA\xB8\xE7\xB1\xBB’ for column ‘type’ at row 1
MySQL添加不了中文是因为字符集不对,修改表的字符集
ALTER TABLE 表名 CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
例子 types是表名
ALTER TABLE types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;