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

Internal Unicode 14.0 collation character sets are NULL

    XMLWordPrintable

Details

    Description

      Using:

      • Linux / MariaDB 10.11.8
      • Windows MariaDB 10.11.6
      • Windows MariaDB 11.4.2

      The Unicode 14.0 collations have the character set values set to NULL.

      SELECT * FROM information_schema.COLLATIONS 
      WHERE CHARACTER_SET_NAME='utf8mb4' 
      OR CHARACTER_SET_NAME IS NULL 
      ORDER BY COLLATION_NAME ASC;
      

      Recently I was finally able to upgrade to a version of MariaDB on a server that supports Unicode 14.0. I prefer low-level programing whenever possible for control and performance reasons. So I directly querying the information_schema table instead of referencing SHOW for example. It doesn't seem right that the CHARACTER_SET_NAME values for the Unicode 14.0 collations are NULL. I don't imagine that the newer collations suddenly don't require character set support.

      This introduces a minor inconvenience for a collation tool I created though I've dealt with much worse from other software. I wouldn't mind some insight in to the correlation and why these values are NULL.

      Attachments

        Issue Links

          Activity

            People

              serg Sergei Golubchik
              JAB Creations John Bilicki
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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