Support » Fixing WordPress » Moved WordPress but lost special characters

  • Hi all,

    I moved WordPress in the way listed in the Codex without any special problems, but now – when everything is running – all special characters for my language (Swedish that is, åäö) are lost and all I see instead of them is a question mark.

    In action:

    The top post was made after the move and displays åäö as it should.


Viewing 11 replies - 1 through 11 (of 11 total)
  • Mark (podz)


    Support Maven

    Try the following:
    Using the exported database, open in it Notepad++

    ‘Select All’
    Change the character encoding to UTF-8 (Format menu it’s in)

    Import that into the database.

    See what happens ?

    Didn’t help.

    Maybe I should do a search and replace for all the åäö’s and ÅÄÖ’s to html-code in the sql-file?

    Ok, so I browsed the imported database on the new server. It says it’s “latin1_swedish_ci” wich sounds about right, and when I’m looking at the posts in MyAdmin I can see åäö so it hasn’t lost them in the exportion or anything.

    Maybe it’s a server setting?

    Any other suggestions?

    I’m really stuck here guys… Any help or suggestions?

    I had (I have, actually…) a similar problem when I copy my database to my test site. I think it’s a problem of the hosting provider, in terms of upload capabilities, especially if have to import a big database. Try the alternative upload option, suggested by Podz: a copy and paste of single chunks of your database, from within phpMyAdmin. Full instructions here:

    I’ll take a look at it, but I’m pretty sure that it isn’t a size issue since it all loads into the database with the right characters.

    I have now eliminated the possibility that it is a server issue. This can also be seen as it works perfectly fine if I post new messages after the restor – old posts get question marks instead of åäö while new gets the right characters, and it all looks the same in the database.

    Man, is this annoying me or what!

    Ok. Tried the above suggestion out of pure frustration. It didn’t help, as expected. (No errors and everything loaded into the database but åäö are questionmarks on the website but in plain text in the database.)

    However, browsing the database made me realize this:

    This is a new post, where åäö works perfectly fine on the site – it displays like this online: åäö (gemener) samt ÅÄÖ (versaler).

    In the database it looks like this: åäö (gemener) samt ÅÄÖ (versaler).

    åäö and ÅÄÖ is not in plain text on new posts (after the move), but old posts show them in plain text!

    What to do? Help, please!

    I managed to solve this. I’m not entirely certain, but it seems that my old server had a fairly old MySQL-database and therefor I needed to make sure I imported it with latin1, not UTF-8 that is specified in the codex.

    Of course, when imported I changed it to UTF-8 because it’s, well, better.

    I see everything works fine now! I will check for my hosting provider database…

    Good luck and let me know if I can help out in any way.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘Moved WordPress but lost special characters’ is closed to new replies.