Pepelac
Well-known member
Hi. Need an advice.
I was trying to import one forum from vB 3.8 and I got problem with usernames.
Both DB are in utf8_general_ci.
The problem is in the fact, that from MySQL's point of view, for example letters (in russian alphabet) "ё" and "е" are the same, so 2 different users with names "Артем" and "Артём" are the same... And this is a problem not only for russian alphabet, for example it is true, that 'u' = 'ü' = 'ů'.
My question is: what I should do with such users? Rename conflicted users, or maybe set collation to utf8_bin instead of utf8_general_ci?
Thx for advices.
I was trying to import one forum from vB 3.8 and I got problem with usernames.
Both DB are in utf8_general_ci.
The problem is in the fact, that from MySQL's point of view, for example letters (in russian alphabet) "ё" and "е" are the same, so 2 different users with names "Артем" and "Артём" are the same... And this is a problem not only for russian alphabet, for example it is true, that 'u' = 'ü' = 'ů'.
My question is: what I should do with such users? Rename conflicted users, or maybe set collation to utf8_bin instead of utf8_general_ci?
Thx for advices.