在进行项目开发时,创建数据库和插入数据的时候,遇到了报错的问题,Incorrect string value: ‘\xB4\xF3\xD1\xA9\xD6\xD0…’ for column 'book’,经过努力,终于解决了,现将解决的方法写下来:
首先在mysql bin目录下输入cmd 回车
mysql -u root -p 回车
输入密码,回车
mysql> SET NAMES utf8mb4;
mysql> SET FOREIGN_KEY_CHECKS=0;
mysql> CREATE DATABASE IF NOT EXISTS db_bookmanage;
mysql> USE db_bookmanage;
mysql> CREATE TABLE user
(
-> id
int(11) NOT NULL AUTO_INCREMENT,
-> account
varchar(30) COLLATE utf8_unicode_ci DEFAULT NULL,
-> password
varchar(30) COLLATE utf8_unicode_ci DEFAULT ‘111111’,
-> name
varchar(20) COLLATE utf8_unicode_ci DEFAULT NULL,
-> type
tinyint(1) DEFAULT ‘2’,
-> PRIMARY KEY (id
),
-> UNIQUE KEY account_user_FK
(account
)
-> ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
mysql> INSERT INTO user
VALUES (‘1’, ‘admin’, ‘111111’, ‘管理员’, ‘1’);
Query OK, 0 rows affected (0.02 sec)
mysql 5.7 插入中文报错 Incorrect string value: ‘\xB4\xF3\xD1\xA9\xD6\xD0...‘ for column ‘book‘
最新推荐文章于 2023-07-09 16:24:16 发布