Early versions of WordPress create Databases using different encoding such as latin1_swedish_ci. As the result, we won’t be able to see Unicode text. We’ll see some kind of curly scripts in the screen. To overcome this problem, we can use a simple solution. That is open your wp-config.php file and do the following edits there.
change it as
This is only a simple temporary solution. You need to change your database to Unicode encoding. If your hosting provider giving you the control panel then you can open phpMyAdmin and change the encoding of each tables and columns to UNICODE encoding.
WordPress also given a solution for this problem, but that is very complex and only DB gurus can understand that guide-lines.
I used UTF-8 Database Converter plug-in, to change the encoding of my E blog. It worked fine, but you should remember that there are some people say that this plug-in has caused problem for them. Make sure you have a back-up of your database.
When you run this UTF-8 Database Converter will give you an error message about the version incompatibility, simply ignore it, because it worked for me.
If you didn’t change the encoding of your WordPress database, in future, especially when you’re transferring your database to a new host.
Please don’t forget to make a back-up. In case anything go wrong you can restore your database back.
Subscribe to our mailing list
Subscribe to our mailing list and receive a free udpates
Thank you for subscribing.
Something went wrong.