emoji图片和编码表

# # Source for table ios_emoji # DROP TABLE IF EXISTS `ios_emoji`; CREATE TABLE `ios_emoji` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增ID', `unicode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Unicode编码', `utf8` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'UTF8编码', `utf16` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'UTF16编码', `sbunicode` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'SBUnicode编码', `filename` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '文件名', `filebyte` longblob COMMENT '文件内容字节', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='ios表情编码表'; # # Dumping data for table ios_emoji # INSERT INTO `ios_emoji` VALUES (1,'U+1F604','0xF0 0x9F 0x98 0x84','0xD83D 0xDE04','E415','smiles_01_01.png',NULL); INSERT INTO `ios_emoji` VALUES (2,'U+1F60A','0xF0 0x9F 0x98 0x8A','0xD83D 0xDE0A','E056','smiles_01_02.png',NULL); INSERT INTO `ios_emoji` VALUES (3,'U+1F603','0xF0 0x9F 0x98 0x83','0xD83D 0xDE03','E057','smiles_01_03.png',NULL); INSERT INTO `ios_emoji` VALUES (4,'U+263A','0xE2 0x98 0xBA','0x263A','E414','smiles_01_04.png',NULL); INSERT INTO `ios_emoji` VALUES (5,'U+1F609','0xF0 0x9F 0x98 0x89','0xD83D 0xDE09','E405','smiles_01_05.png',NULL); INSERT INTO `ios_emoji` VALUES (6,'U+1F60D','0xF0 0x9F 0x98 0x8D','0xD83D 0xDE0D','E106','smiles_01_06.png',NULL); INSERT INTO `ios_emoji` VALUES (7,'U+1F618','0xF0 0x9F 0x98 0x98','0xD83D 0xDE18','E418','smiles_01_07.png',NULL); INSERT INTO `ios_emoji` VALUES (8,'U+1F61A','0xF0 0x9F 0x98 0x9A','0xD83D 0xDE1A','E417','smiles_01_08.png',NULL); INSERT INTO `ios_emoji` VALUES (9,'U+1F633','0xF0 0x9F 0x98 0xB3','0xD83D 0xDE33','E40D','smiles_01_09.png',NULL); INSERT INTO `ios_emoji` VALUES (10,'U+1F60C','0xF0 0x9F 0x98 0x8C','0xD83D 0xDE0C','E40A','smiles_01_10.png',NULL); INSERT INTO `ios_emoji` VALUES (11,'U+1F601','0xF0 0x9F 0x98 0x81','0xD83D 0xDE01','E404','smiles_01_11.png',NULL); INSERT INTO `ios_emoji` VALUES (12,'U+1F61C','0xF0 0x9F 0x98 0x9C','0xD83D 0xDE1C','E105','smiles_02_01.png',NULL); INSERT INTO `ios_emoji` VALUES (13,'U+1F61D','0xF0 0x9F 0x98 0x9D','0xD83D 0xDE1D','E409','smiles_02_02.png',NULL); INSERT INTO `ios_emoji` VALUES (14,'U+1F612','0xF0 0x9F 0x98 0x92','0xD83D 0xDE12','E40E','smiles_02_03.png',NULL); INSERT INTO `ios_emoji` VALUES (15,'U+1F60F','0xF0 0x9F 0x98 0x8F','0xD83D 0xDE0F','E402','smiles_02_04.png',NULL); INSERT INTO `ios_emoji` VALUES (16,'U+1F613','0xF0 0x9F 0x98 0x93','0xD83D 0xDE13','E108','smiles_02_05.png',NULL); INSERT INTO `ios_emoji` VALUES (17,'U+1F614','0xF0 0x9F 0x98 0x94','0xD83D 0xDE14','E403','smiles_02_06.png',NULL); INSERT INTO `ios_emoji` VALUES (18,'U+1F61E','0xF0 0x9F 0x98 0x9E','0xD83D 0xDE1E','E058','smiles_02_07.png',NULL); INSERT INTO `ios_emoji` VALUES (19,'U+1F616','0xF0 0x9F 0x98 0x96','0xD83D 0xDE16','E407','smiles_02_08.png',NULL); INSERT INTO `ios_emoji` VALUES (20,'U+1F625','0xF0 0x9F 0x98 0xA5','0xD83D 0xDE25','E401','smiles_02_09.png',NULL); INSERT INTO `ios_emoji` VALUES (21,'U+1F630','0xF0 0x9F 0x98 0xB0','0xD83D 0xDE30','E40F','smiles_02_10.png',NULL); INSERT INTO `ios_emoji` VALUES (22,'U+1F628','0xF0 0x9F 0x98 0xA8','0xD83D 0xDE28','E40B','smiles_02_11.png',NULL); INSERT INTO `ios_emoji` VALUES (23,'U+1F623','0xF0 0x9F 0x98 0xA3','0xD83D 0xDE23','E406','smiles_03_01.png',NULL); INSERT INTO `ios_emoji` VALUES (24,'U+1F622','0xF0 0x9F 0x98 0xA2','0xD83D 0xDE22','E413','smiles_03_02.png',NULL); INSERT INTO `ios_emoji` VALUES (25,'U+1F62D','0xF0 0x9F 0x98 0xAD','0xD83D 0xDE2D','E411','smiles_03_03.png',NULL); INSERT INTO `ios_emoji` VALUES (26,'U+1F602','0xF0 0x9F 0x98 0x82','0xD83D 0xDE02','E412','smiles_03_04.png',NULL); INSERT INTO `ios_emoji` VALUES (27,'U+1F632','0xF0 0x9F 0x98 0xB2','0xD83D 0xDE32','E410','smiles_03_05.png',NULL); INSERT INTO `ios_emoji` VALUES (28,'U+1F631','0xF0 0x9F 0x98 0xB1','0xD83D 0xDE31','E107','smiles_03_06.png',NULL); INSERT INTO `ios_emoji` VALUES (29,'U+1F620','0xF0 0x9F 0x98 0xA0','0xD83D 0xDE20','E059','smiles_03_07.png',NULL); INSERT INTO `ios_emoji` VALUES (30,'U+1F621','0xF0 0x9F 0x98 0xA1','0xD83D 0xDE21','E416','smiles_03_08.png',NULL); INSERT INTO `ios_emoji` VALUES (31,'U+1F62A','0xF0 0x9F 0x98 0xAA','0xD83D 0xDE2A','E408','smiles_03_09.png',NULL); INSERT INTO `ios_emoji` VALUES (32,'U+1F637','0xF0 0x9F 0x98 0xB7','0xD83D 0xDE37','E40C','smiles_03_10.png',NULL); INSERT INTO `ios_emoji` VALUES (33,'U+1F47F','0xF0 0x9F 0x91 0xBF','0xD83D 0xDC7F','E11A','smiles_03_11.png',NULL); INSERT INTO `ios_emoji` VALUES (34,'U+1F47D','0xF0 0x9F 0x91 0xBD','0xD83D 0xDC7D','E10C','smiles_04_01.png',NULL); INSERT INTO `ios_emoji` VALUES (35,'U+1F49B','0xF0 0x9F 0x92 0x9B','0xD83D 0xDC9B','E32C','smiles_04_02.png',NULL); INSERT INTO `ios_emoji` VALUES (36,'U+1F499','0xF0 0x9F 0x92 0x99','0xD83D 0xDC99','E32A','smiles_04_03.png',NULL); INSERT INTO `ios_emoji` VALUES (37,'U+1F49C','0xF0 0x9F 0x92 0x9C','0xD83D 0xDC9C','E32D','smiles_04_04.png',NULL); INSERT INTO `ios_emoji` VALUES (38,'U+1F497','0xF0 0x9F 0x92 0x97','0xD83D 0xDC97','E328','smiles_04_05.png',NULL); INSERT INTO `ios_emoji` VALUES (39,'U+1F49A','0xF0 0x9F 0x92 0x9A','0xD83D 0xDC9A','E32B','smiles_04_06.png',NULL); INSERT INTO `ios_emoji` VALUES (40,'U+2764','0xE2 0x9D 0xA4','0x2764','E022','smiles_04_07.png',NULL); INSERT INTO `ios_emoji` VALUES (41,'U+1F494','0xF0 0x9F 0x92 0x94','0xD83D 0xDC94','E023','smiles_04_08.png',NULL); INSERT INTO `ios_emoji` VALUES (42,'U+1F493','0xF0 0x9F 0x92 0x93','0xD83D 0xDC93','E327','smiles_04_09.png',NULL); INSERT INTO `ios_emoji` VALUES (43,'U+1F498','0xF0 0x9F 0x92 0x98','0xD83D 0xDC98','E329','smiles_04_10.png',NULL); INSERT INTO `ios_emoji` VALUES (44,'U+2728','0xE2 0x9C 0xA8','0x2728','E32E','smiles_04_11.png',NULL); INSERT INTO `ios_emoji` VALUES (45,'U+1F31F','0xF0 0x9F 0x8C 0x9F','0xD83C 0xDF1F','E335','smiles_05_01.png',NULL); INSERT INTO `ios_emoji` VALUES (46,'U+1F4A2','0xF0 0x9F 0x92 0xA2','0xD83D 0xDCA2','E334','smiles_05_02.png',NULL); INSERT INTO `ios_emoji` VALUES (47,'U+2755','0xE2 0x9D 0x95','0x2755','E337','smiles_05_03.png',NULL); INSERT INTO `ios_emoji` VALUES (48,'U+2754','0xE2 0x9D 0x94','0x2754','E336','smiles_05_04.png',NULL); INSERT INTO `ios_emoji` VALUES (49,'U+1F4A4','0xF0 0x9F 0x92 0xA4','0xD83D 0xDCA4','E13C','smiles_05_05.png',NULL); INSERT INTO `ios_emoji` VALUES (50,'U+1F4A8','0xF0 0x9F 0x92 0xA8','0xD83D 0xDCA8','E330','smiles_05_06.png',NULL); INSERT INTO `ios_emoji` VALUES (51,'U+1F4A6','0xF0 0x9F 0x92 0xA6','0xD83D 0xDCA6','E331','smiles_05_07.png',NULL); INSERT INTO `ios_emoji` VALUES (52,'U+1F3B6','0xF0 0x9F 0x8E 0xB6','0xD83C 0xDFB6','E326','smiles_05_08.png',NULL); INSERT INTO `ios_emoji` VALUES (53,'U+1F3B5','0xF0 0x9F 0x8E 0xB5','0xD83C 0xDFB5','E03E','smiles_05_09.png',NULL); INSERT INTO `ios_emoji` VALUES (54,'U+1F525','0xF0 0x9F 0x94 0xA5','0xD83D 0xDD25','E11D','smiles_05_10.png',NULL); INSERT INTO `ios_emoji` VALUES (55,'U+1F4A9','0xF0 0x9F 0x92 0xA9','0xD83D 0xDCA9','E05A','smiles_05_11.png',NULL); INSERT INTO `ios_emoji` VALUES (56,'U+1F44D','0xF0 0x9F 0x91 0x8D','0xD83D 0xDC4D','E00E','smiles_06_01.png',NULL); INSERT INTO `ios_emoji` VALUES (57,'U+1F44E','0xF0 0x9F 0x91 0x8E','0xD83D 0xDC4E','E421','smiles_06_02.png',NULL); INSERT INTO `ios_emoji` VALUES (58,'U+1F44C','0xF0 0x9F 0x91 0x8C','0xD83D 0xDC4C','E420','smiles_06_03.png',NULL); INSERT INTO `ios_emoji` VALUES (59,'U+1F44A','0xF0 0x9F 0x91 0x8A','0xD83D 0xDC4A','E00D','smiles_06_04.png',NULL); INSERT INTO `ios_emoji` VALUES (60,'U+270A','0xE2 0x9C 0x8A','0x270A','E010','smiles_06_05.png',NULL); INSERT INTO `ios_emoji` VALUES (61,'U+270C','0xE2 0x9C 0x8C','0x270C','E011','smiles_06_06.png',NULL); INSERT INTO `ios_emoji` VALUES (62,'