2018-06-18, 03:56 AM
Hi, I'm trying to use the merge but when importin users I have issue with names with special characters, let me show:
On the phpbb I have two users
jonatas and Jônatas, the encode is utf8_bin, but when mybb try to import, he considere jonatas and Jônatas the same user and because that issue a message of duplicated entry.
Have anyone faced this problem?
Tried a couple of configurations for encode on the merge but nothing worked.
To add more information, I changed the collation of the field username on mybb_users to utf8_bin, someone know if there is some type of problem if I let the field remain as this?
ALTER TABLE
On the phpbb I have two users
jonatas and Jônatas, the encode is utf8_bin, but when mybb try to import, he considere jonatas and Jônatas the same user and because that issue a message of duplicated entry.
Have anyone faced this problem?
Tried a couple of configurations for encode on the merge but nothing worked.
To add more information, I changed the collation of the field username on mybb_users to utf8_bin, someone know if there is some type of problem if I let the field remain as this?
ALTER TABLE
mybb_users
CHANGE username
username
VARCHAR(120) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';