Funny characters after moving server

  • Resolved greencode

    (@greencode)


    14 years, 10 months ago

    I’ve run into the problem that a few others seemed to have faced – that of funny characters appearing when I’ve moved my WP blog to another server.

    I’ve performed the following checks:

    1. The servers have the same version of MySQL
    2. I imported the database with utf8
    3. I’ve run the plugin “UTF-8 Database Converter”
    4. I’ve defined define(‘DB_CHARSET’, ‘utf8’); and define(‘DB_COLLATE’, ”); in wp-confie file.
    5. I’ve also tried commenting the above out to see if that worked.

    Unfortunately none of these had any effect so I’m getting weird characters appear throughout. £ where there should be £ symbols and “ where there should be quote marks.

    Any help with this would grately appreciated.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Thread Starter greencode

    (@greencode)

    14 years, 10 months ago

    Okay, I think (and hope) that I’ve resolved this issue… In the wp-config.php file I changed the following line:

    define(‘DB_COLLATE’, ”);

    to

    define(‘DB_COLLATE’, ‘utf8’);

    Seems to have done the trick?!

    satoridork

    (@satoridork)

    14 years, 6 months ago

    Hi greencode,

    Did you simply upload the wp-config.php file, or did you do a complete rebuild of the MySQL database at the same time?

    I’m dealing with a new hosting company and the MySQL tables use three different character sets! Picture here.

    I’d be happy to know that such a tiny change in the wp-config.php file would lead to such a good result.

    Thread Starter greencode

    (@greencode)

    14 years, 5 months ago

    Apologies for not getting back sooner – I really don’t like this WordPress Support forum where I never receive replies for threads I’ve started! Anyway, yes all I did was to upload the wp-config file and make that tiny change. I’ve done a lot of other moving servers since and have not had this problem since.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Funny characters after moving server’ is closed to new replies.