Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8765

mysqldump silently corrupts 4-byte UTF-8 data

        Details

          Description

          Bug for Oracle MySQL: https://bugs.mysql.com/bug.php?id=71746

          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','','','','','');

            Gliffy Diagrams

              Attachments

                Issue Links

                relates to

                Bug - A problem which impairs or prevents the functions of the product. MDEV-8334 Rename utf8 to utf8mb3

                • Major - Major loss of function.
                • Open
                links to

                Web Link Bug #71746 - mysqldump may use utf8mb4 as default-character-set

                  Activity

                  There are no comments yet on this issue.

                    People

                    • Assignee:
                      bar Alexander Barkov
                      Reporter:
                      dveeden Daniël van Eeden
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      1 Start watching this issue

                      Dates

                      • Created:
                        Updated: