本文共 566 字,大约阅读时间需要 1 分钟。
导入数据库时,出现Incorrect string value: '...' for column
ERROR 1366 (22007) at line 132620 in file: '/home/yanqiu/Downloads/12-28/mysql_data/木蚂蚁/木蚂蚁-13万_mumayi.com.sql': Incorrect string value: '\xC3\xC0\xC0\xF6-\xC9...' for column `mumayi`.`mumayicdb_members`.`username` at row 1
file name.sql
show create table <表明> ; 表明>
ALTER TABLE TABLE_NAME CONVERT TO CHARACTER SET utf8mb4;
ALTER TABLE TABLE_NAME CONVERT TO CHARACTER SET utf8;
:set fileencoding
:set fileencoding=utf-8
转载地址:http://pkevi.baihongyu.com/