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

WBB3 to xF with "äöü" chars

TsinJu

Well-known member
#1
I want to import my wbb forum to xf but special chars are not shown in utf8 Format, in a Thread.

They are shown in Ascii Code? (not sure what it is)
Here is a Picture
blaga7pw5.png

You can see the "äöüß" are shown different.
My Question now is how to convert them into "äöüß" before the import into xf?
Can i do it with any mysql command? Or do i need to edit every Thread?(Hopefully not ;) )

Hope my english is understandable :censored:
 

Brogan

XenForo moderator
Staff member
#2
Are all of the source and XF tables in utf8_general_ci collation?

Which importer did you use?
The problem could be due to the interim import.
 

TsinJu

Well-known member
#3
I was using an IPB before and imported over vb4 to wbb.
Dont know what side made the probs. But you are right, it was because of the Import.
I am always using the utf8 col.
Thought i can get this solved by any msql command to change all the Ascii into something readable ;)
 

Brogan

XenForo moderator
Staff member
#4
You can try simple queries like so:
Code:
UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');