[MDEV-8765] mysqldump silently corrupts 4-byte UTF-8 data - Jira

XML

Word

Printable

But this also affect MariaDB 10.0:

[dvaneeden@dve-mac msb_ma10_0_20]$ ./my sqldump --skip-extended-insert unicodedata | grep DOLPHIN

INSERT INTO `ucd` VALUES ('1F42C','?','DOLPHIN','So','0','ON','','','','','N','','','','','');

[dvaneeden@dve-mac msb_ma10_0_20]$ ./my sqldump --skip-extended-insert --default-character-set=utf8mb4 unicodedata | grep DOLPHIN

INSERT INTO `ucd` VALUES ('1F42C','��','DOLPHIN','So','0','ON','','','','','N','','','','','');

relates to

MDEV-7128 Configuring charsets or collations as utf8 yields surprising result and leads to data loss

MDEV-8334 Rename utf8 to utf8mb3

links to