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
23
XenForo General Discussions
Kirby
K
X
Solved XF responsive design breakpoints ignore DPI & modern high resolution phones
Replies
0
Views
73
XenForo General Discussions
Xon
X
X
Bug XF responsive design breakpoints ignore DPI & modern high resolution phones
Replies
0
Views
66
XenForo General Discussions
Xon
X
A
XenForo Very strange problem in new standardstyle Modern
Replies
0
Views
374
XenForo Development & Modifications
Abraham54
A
S
Bug Search logs: XF\Db\Exception: MySQL fetch error [2014]
Replies
0
Views
38
XenForo General Discussions
soloarquitectura
S
Top Bottom
Back