Can't use modern MySQL / MariaDB collations

XenForo currently uses hardcoded collation utf8mb4_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 utf8mb4_uca1400_as_ci quite some time ago and made utf8mb4_uca1400_ai_ci default in 11.6:

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

jira.mariadb.org
...

Read more

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