CODEWITHSUNDEEP
mysqlmariadbcollation
pantonis
pantonis

Reputation: 6467

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

Upvotes: 2

Views: 3717

Answers (2)

Rick James
Rick James

Reputation: 142298

Reopened because the dupe:

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 they have skipped to 14.0.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.

Upvotes: 1

danblack
danblack

Reputation: 14666

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.

Upvotes: 6

Related Questions