[MySQL] ERROR 1406 (22001): Data too long for column xxx

问题描述

在向 MySQL 导入数据时遇到如题报错, 看样子应该是编码错误, 但修改数据库编码没用. 现有两个 MySQL 服务端运行在两台不同的服务器上面, 使用 show variables like "%char%"查看数据库编码, 结果如下

• mysql1

character_set_client        utf8
character_set_connection    utf8
character_set_database      latin1
character_set_filesystem    binary
character_set_results   
character_set_server        latin1
character_set_system        utf8
character_sets_dir          /usr/share/mysql/charsets/

• mysql2

character_set_client        utf8mb4
character_set_connection    utf8mb4
character_set_database      utf8mb4
character_set_filesystem