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: https://www.tdh.se

    The top post was made after the move and displays ?￥?¤?? as it should.

    Help?

Viewing 11 replies - 1 through 11 (of 11 total)

  • Try the following:
    Using the exported database, open in it Notepad++
    https://notepad-plus.sourceforge.net/uk/download.php

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

    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?

    Thread Starter Thord D. Hedengren

    (@tdh)

    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:

    https://www.tamba2.org.uk/wordpress/restore/

    Thread Starter Thord D. Hedengren

    (@tdh)

    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!

    Thread Starter Thord D. Hedengren

    (@tdh)

    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 ??a€|??a€???a€“ (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!

    Thread Starter Thord D. Hedengren

    (@tdh)

    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…

    Thread Starter Thord D. Hedengren

    (@tdh)

    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.