Warning: Non-US characters in user name (General)
Hello
I have a Swedish forum there some of the users have Swedish characters in their user names. I have now noticed that if two users have user names that looks alike but are different, they will not be able to login.
Example:
One user has the user name "daniel" and the other user has the user name "däniel".
I can confirm this misbehaviour in one of <del>
my accessible</del>
servers <ins>
I have access to</ins>
. The reason is the use of the collation utf8_general*
. A blog entry (in german language) offers a solution, the use of the collation utf8_bin
. But this has the same issues like your unique index and has to be implemented equally careful.
Tschö, Auge
--
Trenne niemals Müll, denn er hat nur eine Silbe!