RSS Feed/News Can't use modern MySQL / MariaDB collations

Status
Not open for further replies.

ENXF NET

Administrator
Staff member
Administrator
Moderator
+Lifetime VIP+
S.V.I.P.S Member
S.V.I.P Member
V.I.P Member
Collaborate
Registered
Joined
Nov 13, 2018
Messages
25,817
Points
823

Reputation:

XenForo currently uses utf8_mb4_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 uca1400_as_ci quite some time ago and made a UCU collation default in 11.6:

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

jira.mariadb.org
jira.mariadb.org

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

jira.mariadb.org
jira.mariadb.org

MySQL 8 at...

Read more

Continue reading...
 
Status
Not open for further replies.
Top