Use collation utf8mb4_0900_ai_ci
Virtual Research Environment / On-line Bibliography Manager
Brought to you by:
sirfragalot
Collation utf8mb4_0900_ai_ci is available since MySQL 8.0.0 and MariaDB 11.4.5 and is an alias of utf8mb4_uca1400_nopad_ai_ci.
See https://mariadb.com/kb/en/mariadb-11-4-5-release-notes/#character-setscharacter-sets-and-collations
See https://dev.mysql.com/doc/relnotes/mysql/8.0/en/news-8-0-0.html#mysqld-8-0-0-charset