mysql导入数据库出现:Incorrect string value: '\xE7\x82\xB9\xE9\x92\x9F' for column 'chinese' at row 1

时间:2021-09-09 20:12:47

mysql导入数据库出现:Incorrect string value: '\xE7\x82\xB9\xE9\x92\x9F' 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:\xampp\mysql\share\charsets\