Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
Normal
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:[URL unfurl="true"]https://jira.mariadb.org/browse/MDEV-27009[/URL][URL unfurl="true"]https://jira.mariadb.org/browse/MDEV-19123[/URL]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?
XenForo currently uses hardcoded collation utf8mb4_general_ci which treats usernames like Günther and Gunther as identical (which might not be desired).
utf8mb4_general_ci
Günther
Gunther
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:
utf8mb4_uca1400_as_ci
utf8mb4_uca1400_ai_ci
[URL unfurl="true"]https://jira.mariadb.org/browse/MDEV-27009[/URL]
[URL unfurl="true"]https://jira.mariadb.org/browse/MDEV-19123[/URL]
MySQL 8 at least supports UCA 9 utf8mb4_0900_as_ci.
utf8mb4_0900_as_ci
Could we have a config.php setting so the collation becomes configurable and thus such collations could be used?
config.php
We use essential cookies to make this site work, and optional cookies to enhance your experience.
See further information and configure your preferences
