1. 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

Discussion in 'XenForo Questions and Support' started by TsinJu, Mar 23, 2013.

  1. TsinJu

    TsinJu Well-Known Member

    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

    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:
  2. Brogan

    Brogan XenForo Moderator Staff Member

    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.
  3. TsinJu

    TsinJu Well-Known Member

    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 ;)
  4. Brogan

    Brogan XenForo Moderator Staff Member

    You can try simple queries like so:
    UPDATE xf_post SET message = REPLACE(message,'current_content','new_content');
  5. TsinJu

    TsinJu Well-Known Member

    thanks Borgan, i will try it.

Share This Page