• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

XF 1.2 Importing accents from vB4

Mike

XenForo developer
Staff member
#2
In general, the only way to properly fix it -- as it will run through every bit of your data -- is to redo the import and force a character set at the beginning, probably "latin1". The data that we receive from MySQL has been double encoded; doing that change prevents the extra encode.
 

Claudio

Well-known member
#3
In general, the only way to properly fix it -- as it will run through every bit of your data -- is to redo the import and force a character set at the beginning, probably "latin1". The data that we receive from MySQL has been double encoded; doing that change prevents the extra encode.
if I set latin1 I get the following error when I import custom user fields and I can't continue with the import:

Code:
Mysqli statement execute error : Incorrect string value: '\xE1\xE0\xE9\xE8\xED\xF3...' for column 'match_regex' at row 1