Place Your Ad Here

Solved Can't use modern MySQL / MariaDB collations

This topic has been solved
K

Kirby

Guest
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
jira.mariadb.org
...

Read more

Continue reading...
 
You must log in or register to reply here.

Similar threads

K
Bug Can't use modern MySQL / MariaDB collations
Replies
0
Views
173
XenForo General Discussions
Kirby
K
X
Solved XF responsive design breakpoints ignore DPI & modern high resolution phones
Replies
0
Views
219
XenForo General Discussions
Xon
X
X
Bug XF responsive design breakpoints ignore DPI & modern high resolution phones
Replies
0
Views
198
XenForo General Discussions
Xon
X
A
XenForo Very strange problem in new standardstyle Modern
Replies
0
Views
511
XenForo Development & Modifications
Abraham54
A
P
XenForo MySQL process Q
Replies
0
Views
60
XenForo Development & Modifications
pilot823
P
Top Bottom
Back