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

Change NATIONAL from utf8mb3 to utf8mb4

    XMLWordPrintable

Details

    Description

      Data types NCHAR and NVARCHAR use CHARACTER SET utf8mb3.
      With the general intent to switch from utf8mb3 to utf8mb4, this should also be fixed:

      • either to hard-coded utf8mb4
      • or according to UTF8_IS_UTF8MB3

      CREATE OR REPLACE TABLE t1 (a NCHAR);
      SHOW CREATE TABLE t1;
      

      +-------+-------------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                                |
      +-------+-------------------------------------------------------------------------------------------------------------+
      | t1    | CREATE TABLE `t1` (
        `a` char(1) CHARACTER SET utf8mb3 DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
      +-------+-------------------------------------------------------------------------------------------------------------+
      

      Attachments

        Issue Links

          Activity

            People

              bar Alexander Barkov
              bar Alexander Barkov
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.