mysql 5 插入数据有不识别字符问题 解决方法

   注意：本文试用于试用insert插入数据时，产生不识别Incorrect string value: '\xF0\x9F\x92\xBC' for column 'Rins' at row 1 at 的问题

    最近在写一个爬虫爬医学相关网站，其中遇到了  Incorrect string value: '\xF0\x9F\x92\xBC' for column 'Rins' at row 1 at 错误

    经过一番谷歌百度后得知 Mysql 数据库的默认 utf-8 只识别最多3个字符的 utf-8 编码，当遇到一些生僻的字或者符号时就会报上述错误

    解决方法就是在创建表格的时候将默认的 utf-8 字符改为 CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci  

  

    具体如下所示：

               

CREATE TABLE `cdd` (  `cdd_ID` int(11) NOT NULL,  `url` varchar(255) NOT NULL,  `title` varchar(255) NOT NULL,  `english_name` varchar(255) NOT NULL COMMENT '英文名',  `alias` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT '别名',  `department` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '疾病分类',  `icd_num` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'ICD号',  `summary` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '概述',  `epidemiology` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '流行病学',  `pathogen` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,  `nosogenesis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '发病机制',  `clinical_manifestation` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '临床表现',  `complication` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '并发症',  `laboratory_examination` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '实验室检查',  `auxiliary_examination` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '辅助检查',  `diagnose` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '诊断',  `antidiastole` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '鉴别诊断',  `cure` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '治疗',  `prognosis` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '预后',  `precaution` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '预防',  PRIMARY KEY (`cdd_ID`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;