// -- Dump used for restoring https://raw.githubusercontent.com/dveeden/mysqlunicodedata/master/ucd_data.sql DROP TABLE IF EXISTS `ucd`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `ucd` ( `value` varchar(6) NOT NULL, `char` char(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL, `name` varchar(100) DEFAULT NULL, `category` enum('Cc','Cf','Co','Cs','Ll','Lm','Lo','Lt','Lu','Mc','Me','Mn','Nd','Nl','No','Pc','Pd','Pe','Pf','Pi','Po','Ps','Sc','Sk','Sm','So','Zl','Zp','Zs') NOT NULL, `combining_class` varchar(20) DEFAULT NULL, `bidi_class` enum('AL','AN','B','BN','CS','EN','ES','ET','FSI','L','LRE','LRI','LRO','NSM','ON','PDF','PDI','R','RLE','RLI','RLO','S','WS') NOT NULL, `decomposition` varchar(100) DEFAULT NULL, `numeric1` varchar(20) DEFAULT NULL, `numeric2` varchar(20) DEFAULT NULL, `numeric3` varchar(20) DEFAULT NULL, `bidi_mirrored` enum('N','Y') NOT NULL, `unicode1_name` varchar(100) DEFAULT NULL, `ISO_comment` char(0) DEFAULT NULL, `uppercase_mapping` varchar(5) DEFAULT NULL, `lowercase_mapping` varchar(5) DEFAULT NULL, `titlecase_mapping` varchar(5) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; // 5.7.9 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.9: cat docs/INFO_SRC commit: 59cabe2ee6e9a2bf8b07c93f5fae44692294b947 date: 2015-09-04 14:41:39 +0200 build-date: 2015-09-04 15:41:10 +0200 short: 59cabe2 branch: mysql-5.7 MySQL source 5.7.9 [umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.9: bin/mysqlpump -uroot -S /tmp/mysql_ushastry.sock --databases test --skip-extended-insert | grep DOLPHIN mysqlpump: [Warning] option 'extended-insert': unsigned value 0 adjusted to 1 Dump progress: 0/1 tables, 1/27648 rows INSERT INTO `test`.`ucd` VALUES ("1F42C","🐬","DOLPHIN","So","0","ON",'','','','',"N",'','','','',''); Dump completed in 384 milliseconds // 5.7.8 [umshastr@hod03]/export/umesh/server/binaries/mysql-5.7.8-rc: bin/mysqlpump -uroot -S /tmp/mysql_ushastry.sock --databases test --skip-extended-insert | grep DOLPHIN mysqlpump: [Warning] option 'extended-insert': unsigned value 0 adjusted to 1 Dump progress: 0/1 tables, 1/30592 rows INSERT INTO `test`.`ucd` VALUES ("1F42C","?","DOLPHIN","So","0","ON",'','','','',"N",'','','','',''); Dump completed in 402 milliseconds