merge-system icon indicating copy to clipboard operation
merge-system copied to clipboard

Merge system - issue importing from phpbb3 utf8-bin - duplicated entrie

Open edipoferreira opened this issue 6 years ago • 3 comments

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.

edipoferreira avatar Jun 19 '18 22:06 edipoferreira