WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Funny characters after moving server (4 posts)

  1. greencode
    Member
    Posted 5 years 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.

  2. greencode
    Member
    Posted 5 years 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?!

  3. satoridork
    Member
    Posted 4 years 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.

  4. greencode
    Member
    Posted 4 years 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.

Topic Closed

This topic has been closed to new replies.

About this Topic