===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.
* ((https://mariadb.com/kb/en/supported-character-sets-and-collations/ MariaDB collations))
* ((https://dev.mysql.com/doc/refman/8.0/en/charset-collation-names.html MySQL collations))
* ((http://www.unicode.org/Public/UCA/9.0.0/allkeys.txt UCA 9.0.0))
* ((http://www.unicode.org/Public/UCA/14.0.0/allkeys.txt UCA 14.0.0))
===SQL modes===