XF 1.2 Character issues

[tommydamic68]

I have some older threads that have character issues. Is there a fix for this?

 

[tommydamic68]

Anyone? Was this an import error perhaps?

 

[Amaury]

It's an issue with importing from vBulletin.

@mistypants had the same issue when she moved KH-Vids from vBulletin to XenForo, though I'm not sure if a fix was ever found.

 

[Paul B]

You can run SQL queries to update the text.

UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');

Take a backup first.

 

[EQnoble]

I don't what would cause this but it looks like it is fixable (looks like replaceable sequences) with this addon - http://xenforo.com/community/resources/post-content-find-replace.1549/