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

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\

posted @ 2015-09-19 17:58  aprial  阅读(2391)  评论(0编辑  收藏  举报