Can't use modern MySQL / MariaDB collations

XenForo currently uses utf8_mb4_general_ci which treats usernames like Günther and Gunther as identical (which might not be desired).

This collation is kinda old and lacking proper support for many unicode characters.

MariaDB added support for more modern UCA 14 collations like uca1400_as_ci quite some time ago and made a UCU collation default in 11.6:

[MDEV-27009] Add UCA-14.0.0 collations - Jira ​

jira.mariadb.org

[MDEV-19123] Change default charset from latin1 to utf8mb4 - Jira ​

jira.mariadb.org

MySQL 8 at...

Read more

Читать далее...