Upgraded To Bigger Sever and Now Weird Characters ?

  • Resolved wethead

    (@wethead)


    15 years, 4 months ago

    Hi,

    I used the wordpress back up plugin and had my database in a gzip format,

    I switched to a bigger server and imported my database using big dump.php

    Now on my pages / articles I am getting all kinds of weird chars

    for example :

    You wona€?t is supposed to be “You Won’t”

    My config.php reads

    define(‘DB_HOST’, ‘localhost’); // 99% chance you won’t need to change this value
    define(‘DB_CHARSET’, ‘utf8’);

    and my database rows say utf8_general_ci

    Can someone please tell me how I can remove this problem?

    Thanks so much in advance

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

  • Hi wethead:

    I’ve got this problem too, and there are some kinds of ways to resolve this little problem.

    Some people search and replace for each strange chcaracter and replace it by the correct one… for me was the worst way to do it.

    After seeing your post, I could know the correct answere. It is a problem of encoding, so I did the change:

    define(‘DB_CHARSET’, ‘utf8’);

    for

    define(‘DB_CHARSET’, ‘utf8_general_ci’);

    in the wp-config.php file. et voilá, it works as a charm.

    So the solution is to now what is the proper charset of the DB in order to WP use the info in a right way.

    I hope helps somebody in the future.

    yes! i changed:

    define(‘DB_CHARSET’, ‘utf8’);

    to

    define(‘DB_CHARSET’, ‘utf8_general_ci’);

    and the weird characters went away. thanks!

    Thread Starter wethead

    (@wethead)

    Thanks guys!!

    I just saw you replied now, but I wanted to say thanks,!

    I found out what caused my problem as well.

    I was using “bigdump.php” to import my database and when I did, I never set the char encoding to UTF-8.

    So what I did was just re-imported a back up copy of the database and then made sure that the big dump php was set to UTF 8

    Thanks again guys!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Upgraded To Bigger Sever and Now Weird Characters ?’ is closed to new replies.