针对MySQL中使用插入语句时,不能插入中文。报错如下:Incorrect string value: ‘\xE5\xBC\xA0\xE4\xB8\x89‘ for column ‘name‘ at
CREATE TABLE stuinfo(
id INT,
NAME VARCHAR(20),
grade FLOAT
);
INSERT INTO `stuinfo`(id,NAME,grade) VALUES(3,'张三',20.3);
ALTER TABLE stuinfo CHANGE NAME NAME VARCHAR(20) CHARACTER SET utf8;
针对MySQL中使用插入语句时,不能插入中文。报错如下:Incorrect string value: ‘\xE5\xBC\xA0\xE4\xB8\x89‘ for column ‘name‘ at
CREATE TABLE stuinfo(
id INT,
NAME VARCHAR(20),
grade FLOAT
);
INSERT INTO `stuinfo`(id,NAME,grade) VALUES(3,'张三',20.3);
ALTER TABLE stuinfo CHANGE NAME NAME VARCHAR(20) CHARACTER SET utf8;