Changing the database collation to the MySQL 8.0 default "utf8mb4_unicode_ci"

By default, XenForo uses the MySQL collation "utf8mb4_general_ci" which is supported not only by MySQL 8.0 but by older MySQL versions like 5.7, too. In MySQL 8.0, the new collation "utf8mb4_unicode_ci" became the default. It is more modern and has better performance.

Since "utf8mb4_unicode_ci" is accent-insensitive ("ai"), some usernames that are considered to be different in "utf8mb4_general_ci" are considered to be equal in "utf8mb4_unicode_ci" which means there will be...

Read more

Continue reading...