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

Allow full utf8mb4 for identifiers

    XMLWordPrintable

    Details

      Description

      Identifier names can't contain characters outside of BMP, i.e they are restricted to utf8mb3
      Here is a relevant part of Slack discussion on why it is so, and on possible fix

      ... discussion on character_set_system  and why it is utf8mb3...
      ....
      bar Oct 13th, 2021 at 4:23 PM
      @wlad yes, it's hard-coded. I think the biggest problem is to implement table-name-to-file-name encoding for non-BMP characters. Should be doable but needs some time.
      5 replies
       
      wlad  3 months ago
      so, a surrogate pair won't do? like, @d801@dc37
       
      bar  3 months ago
      for characters that do not have lower/upper variants, it will do.
       
      bar  3 months ago
      It will actually do for characters that have lower/upper variants as well.
       
      bar  3 months ago
      Thanks for the good idea.
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              bar Alexander Barkov
              Reporter:
              wlad Vladislav Vaintroub
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.