mysql导入数据库出现:Incorrect string value: 'xE7x82xB9xE9x92x9F' for column 'chinese' at row 1

mysql导入数据库出现:Incorrect string value: 'xE7x82xB9xE9x92x9F' for column 'chinese' at row 1

使用 show variables like 'character%' 查看数据库的编码, 如下:

character_set_client    utf8mb4
character_set_connection    utf8mb4
character_set_database    latin1
character_set_filesystem    binary
character_set_results    utf8mb4
character_set_server    latin1
character_set_system    utf8
character_sets_dir    C:xamppmysqlsharecharsets

原文地址:https://www.cnblogs.com/zhang-pengcheng/p/4821917.html