Warning: Non-US characters in user name (General)

by danielb987, Tuesday, April 18, 2017, 16:46 (71 days ago) @ Auge
edited by Auge, Wednesday, April 19, 2017, 09:42

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

In the case with the user name, it is a problem. But in general I think this is a very useful feature. For example, a danish user may search for a word with the letter Ø then the word contains the Swedish letter Ö.

Best regards
Daniel


Complete thread:

 RSS Feed of thread

powered by my little forum