Incorrect string value: ‘‘\\xE5\\x87\\xBA\\xE4\\xBB\\xBB...‘‘ for column ‘‘note_describe‘‘ at row 1

这个是字符编码的问题,设置编码格式就好了

在表中设置

CREATE TABLE zs_major (
zs_zydm VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
zs_zymc VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
zs_pycc VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
zs_pylb VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
zs_ylqrs VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
zs_slqrs VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL,
zs_lqfs VARCHAR(255) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=INNODB DEFAULT CHARSET=utf8

创建库时设置

create database blog default character set utf8;