Stange Characters After Move

  • thunderclap82

    (@thunderclap82)


    15 years, 1 month ago

    I moved our WP site from one VPS to another. After the move, stange characters have appeared where quotes and other punctuation once were. Example: “, ” and Â.

    At first I thought this might have been because our original server was 64-bit, and the new one is 32-bit (although it’s the same OS). But after setting two virtual machines (one running 64-bit, the other 32-bit) the problem is still present.

    It then looked like it may have had to do with the database and the collation it uses. I tried changing all tables to utf8_general_ci from latin1_swedish_ci (right now it’s a mix), but no matter what I do, re-importing the database keeps the tables in their original exported collation. And even if I don’t re-import the database their collations don’t change.

    I tried running the WP plug-in UTF-8 Database Converter (http://ww.wp.xz.cn/extend/plugins/utf-8-database-converter/) but it stops during the conversation and generates an error. (I think this may have to do with 64-bit vs 32-bit). In any case, none of the collations change.

    Any ides how I can fix this problem and get the right punctuation to display without manually cleaning everything up?

Viewing 5 replies - 1 through 5 (of 5 total)
  • converting2wp

    (@converting2wp)

    15 years, 1 month ago

    This may or may not work for you — but when I had the problem a few months ago, and the support folks at Dreamhost told me
    ===========
    This is a fairly common display issue. If you’re seeing it in WordPress, a way that tends to work fairly well is to add

    define(‘DB_CHARSET’, ‘utf8’);

    to wp-config.php if it’s not already in there. It may be already
    commented out (have “//” before it). That usually takes care of the odd
    display.
    ============
    and it helped

    Thread Starter thunderclap82

    (@thunderclap82)

    15 years, 1 month ago

    That actually doubles the characters. :/

    kmessinger

    (@kmessinger)

    15 years, 1 month ago

    I changed all the collations in my db and that didn’t work but when I saw that the define(‘DB_CHARSET’, ‘utf8’); doubled the characters for you thunderclap82, I deleted it from my wp-config and all the junk characters went away!

    Thanks for the unintended fix 🙂

    Thread Starter thunderclap82

    (@thunderclap82)

    15 years, 1 month ago

    Well I’m happy it fixed your problem kmessinger. 🙂 Unfortunately I’m still stuck.

    Thread Starter thunderclap82

    (@thunderclap82)

    15 years, 1 month ago

    Okay… I’ve managed to clean up the vast majority of the incorrect characters except for Ã. I’m trying to use the command

    update <table>
set <field> = replace(<field>,'Ã',' ');

    but changing the à to what I thought was a space gives me a black triangle. I’ve also tried without the space between the apostrophes but it doesn’t work either.

    So, my question is how can I either completely delete the Ã, or how can I change it to a blank space?

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

The topic ‘Stange Characters After Move’ is closed to new replies.