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

Add support for missing MySQL collations

Details

    Description

      MySQL 8 supports a number of collations that MariaDB doesn't. MariaDB doesn't support the gb18030 charset (MDEV-7495) , but there are also numerous unsupported utf8mb4 collations that MariaDB should support:

      gb18030_bin
      gb18030_chinese_ci
      gb18030_unicode_520_ci
      utf8mb4_0900_ai_ci
      utf8mb4_0900_as_ci
      utf8mb4_0900_as_cs
      utf8mb4_0900_bin
      utf8mb4_cs_0900_ai_ci
      utf8mb4_cs_0900_as_cs
      utf8mb4_da_0900_ai_ci
      utf8mb4_da_0900_as_cs
      utf8mb4_de_pb_0900_ai_ci
      utf8mb4_de_pb_0900_as_cs
      utf8mb4_eo_0900_ai_ci
      utf8mb4_eo_0900_as_cs
      utf8mb4_es_0900_ai_ci
      utf8mb4_es_0900_as_cs
      utf8mb4_es_trad_0900_ai_ci
      utf8mb4_es_trad_0900_as_cs
      utf8mb4_et_0900_ai_ci
      utf8mb4_et_0900_as_cs
      utf8mb4_hr_0900_ai_ci
      utf8mb4_hr_0900_as_cs
      utf8mb4_hu_0900_ai_ci
      utf8mb4_hu_0900_as_cs
      utf8mb4_is_0900_ai_ci
      utf8mb4_is_0900_as_cs
      utf8mb4_ja_0900_as_cs
      utf8mb4_ja_0900_as_cs_ks
      utf8mb4_la_0900_ai_ci
      utf8mb4_la_0900_as_cs
      utf8mb4_lt_0900_ai_ci
      utf8mb4_lt_0900_as_cs
      utf8mb4_lv_0900_ai_ci
      utf8mb4_lv_0900_as_cs
      utf8mb4_pl_0900_ai_ci
      utf8mb4_pl_0900_as_cs
      utf8mb4_ro_0900_ai_ci
      utf8mb4_ro_0900_as_cs
      utf8mb4_ru_0900_ai_ci
      utf8mb4_ru_0900_as_cs
      utf8mb4_sk_0900_ai_ci
      utf8mb4_sk_0900_as_cs
      utf8mb4_sl_0900_ai_ci
      utf8mb4_sl_0900_as_cs
      utf8mb4_sv_0900_ai_ci
      utf8mb4_sv_0900_as_cs
      utf8mb4_tr_0900_ai_ci
      utf8mb4_vi_0900_ai_ci
      utf8mb4_vi_0900_as_cs
      utf8mb4_zh_0900_as_cs

      Attachments

        Issue Links

          Activity

            Dubois Jean added a comment -

            I wish this would get resolved, it's a major problem for me and I seem to have found no work-around to it
            I basically need utf8mb4_0900_as_ci so when I SELECT a table where COLUMN = "Warrior" for example, then "WÂRRÏOR" wouldn't be considered, but "WARRIOR" would.

            I guess I'll need to use something else than MariaDB

            Dubois Jean added a comment - I wish this would get resolved, it's a major problem for me and I seem to have found no work-around to it I basically need utf8mb4_0900_as_ci so when I SELECT a table where COLUMN = "Warrior" for example, then "WÂRRÏOR" wouldn't be considered, but "WARRIOR" would. I guess I'll need to use something else than MariaDB
            danblack Daniel Black added a comment -

            For the 0900 collations can we alias them to the existing UCA 1400 collations for the purposes of SQL compatibility.

            How likely are incompatible standard aspects likely to hit the average user?

            danblack Daniel Black added a comment - For the 0900 collations can we alias them to the existing UCA 1400 collations for the purposes of SQL compatibility. How likely are incompatible standard aspects likely to hit the average user?
            danblack Daniel Black added a comment -

            0900 aliases to 1400 have been added in MDEV-20912

            GB18030 is a separate task MDEV-7495

            So I don't see anything left to do?

            danblack Daniel Black added a comment - 0900 aliases to 1400 have been added in MDEV-20912 GB18030 is a separate task MDEV-7495 So I don't see anything left to do?
            greenman Ian Gilfillan added a comment -

            Yes, it looks like the GB18030 charset and its related collations is the only thing still to do.

            greenman Ian Gilfillan added a comment - Yes, it looks like the GB18030 charset and its related collations is the only thing still to do.

            People

              Unassigned Unassigned
              greenman Ian Gilfillan
              Votes:
              3 Vote for this issue
              Watchers:
              7 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.