Collation

MariaDB 10.10 → UCA 14.0.0
uca1400_ai_ci

MySQL 8.0 → UCA 9.0.0
utf8mb4_0900_ai_ci

Smallest common denominator:
utf8mb4_unicode_520_ci

Implications

When migrating from MariaDB to MySQL or vice versa and you're using an incompatible collation you have to change that collation by hand in your config file as well replace it in your database dump or backup.

• MariaDB collations
• MySQL collations
• UCA 9.0.0
• UCA 14.0.0

SQL modes