XF 1.2 Importing accents from vB4

[Claudio]

I've successfully exported a vBulletin 4 spanish forum to XenForo.

However, all accents (áéóíóñ) have been replaced by strange characters like í replaced by à and ó replaced by ó.

The only thread I was able to find about this is http://xenforo.com/community/threads/importing-vb3-8-special-characters-bug.6742/ but it was reported as a bug and was marked as fixed.

Any suggestions?

 

[Mike]

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]

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:

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