Question 112802 in Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – MariaDB utf8mb4_0900_as_cs collation error

I’m trying to switch to MariaDB from mysql 8. I downloaded latest MariaDb 10.10.1 RC version, trying to import backup created from mysql using mysqldump and I get the following error
Unknown collation 'utf8mb4_0900_as_cs'

What is the equivalent collation in MariaDB. Since this question has been closed due to similar question already answered. Similar question is about utf8mb4_0900_ai_ci which is different than what asked here and there is no answer about the collation that I asked. So I would please don’t close it again

Tags:

2

Answers


  1. 0

    (Reopened because the dup (I have that error"#1273 – Unknown collation: 'utf8mb4_0900_ai_ci'") referred to only 5.7.)

    MariaDB does not (yet) have the equivalent of Unicode’s 9.0.0; they are still on 5.2.0.

    For most applications, you can change to utf8mb4_unicode_520_ci and get the same results. (I checked all western European characters.)

    Unfortunately, that requires editing the dump file. –

    Login or Signup to reply.
  2. 0

    MariaDB-10.10.0 has UCA 14.0.0 collations, newer than MySQL’s UCA 9.0.0 collations (finally), which are a result of MDEV-27009.

    So the equivalent collation is uca1400_as_cs.

    Note: 10.10.2 GA is coming very soon.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search