As designed Two usernames are treated as equal

[Akesson]

Affected version

v2.1.6 Patch 1

Håkan
Hakan

Is treated as the same username, which means that Håkan is now called Håkan1 after import. Can it be changed to be treated as two different usernames?

 

[Mike]

This is as expected and there isn't an option around it. It comes from MySQL's collations which are accent insensitive and thus the two names are considered identical within MySQL (and thus would violate the unique username restriction within that).

 

[Christer L]

The collation choosen by XenForo when creating the database is either utf8mb4_general_ci or utf8_general_ci, this controls the case folding and what characters are considered equal.

With the _general collations, letters "a", "å" and "ä" are considered equal.
In the Swedish language, they are not equal and also sort differently.

Here you can see what letters are considered equal in different collations.

MySQL Collations for Version 5.6.12-log

mysql.rjweb.org

If you came from a database that had a _swedish_ci collation (ie where Hakan and Håkan are not equal) , and import into one with _general_ci you get this problem. You should be able to change your collation to the swedish collation before importing, at least on the username colum.
I think that should solve that problem.

It would be great if XenForo setup offered this choice, but you can change it easily yourself with MySQL tools like phpmyadmin.