batch insert 导入带 emoji 的数据到使用 utf8mb4 的表中报错

我把表结构直接贴出来文本吧：

*************************** 1. row ***************************
       Table: game_character
Create Table: CREATE TABLE `game_character` (
  `_id` bigint(20) unsigned NOT NULL,
  `uid` bigint(20) unsigned NOT NULL,
  `gid` bigint(20) unsigned NOT NULL,
  `gtype` int(10) unsigned NOT NULL,
  `name` varchar(32) NOT NULL,
  `tCreate` bigint(20) NOT NULL DEFAULT '0',
  `in_use` tinyint(1) NOT NULL DEFAULT '1',
  `tDelete` bigint(20) unsigned NOT NULL DEFAULT '0',
  UNIQUE KEY `uni_gid_gtype_name` (`gid`,`gtype`,`name`),
  KEY `uid_gid` (`uid`,`gid`),
  KEY `_id` (`_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin