WordPress.org

1. wethead
   Member
   Posted 3 years 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 won’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

2. vegaroy13
   Member
   Posted 3 years ago #
   

   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.

3. rgalpin
   Member
   Posted 3 years ago #
   

   yes! i changed:

   define('DB_CHARSET', 'utf8');

   to

   define('DB_CHARSET', 'utf8_general_ci');

   and the weird characters went away. thanks!

4. wethead
   Member
   Posted 2 years ago #
   

   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!

Topic Closed

This topic has been closed to new replies.