Fixed Can't use modern MySQL / MariaDB collations

[Kirby]

Affected version

2.3.3

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

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

jira.mariadb.org

MySQL 8 at least supports UCA 9 utf8mb4_0900_as_ci.

Could we have a config.php setting so the collation becomes configurable and thus such collations could be used?

 

[XF Bug Bot]

Thank you for reporting this issue, it has now been resolved. We are aiming to include any changes that have been made in a future XF release (2.3.4).

Change log:

Make the default table collation configurable

There may be a delay before changes are rolled out to the XenForo Community.