Details
-
New Feature
-
Status: Needs Feedback (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
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
- duplicates
-
MDEV-20772 Missing collations after upgrade to 10.4
-
- Closed
-
- includes
-
MDEV-35256 Alias MySQL 900 collations into MariaDB 1400 collations
-
- Closed
-
- is part of
-
MDEV-28906 MySQL 8.0 desired compatibility
-
- Open
-
- relates to
-
MDEV-20912 Add support for utf8mb4_0900_* collations in MariaDB Server
-
- Closed
-
-
MDEV-7495 Support GB18030 character set
-
- Open
-
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