merge-system
merge-system copied to clipboard
Merge system - issue importing from phpbb3 utf8-bin - duplicated entrie
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 mybb_users
CHANGE username
username
VARCHAR(120) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '';
Appears that I will be unable to migrate from phpbb3 due this encoding issue.