WordPress Database and Unicode

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.

define(‘DB_CHARSET’, ‘utf8′);
define(‘DB_COLLATE’, ”);

change it as

//define(‘DB_CHARSET’, ‘utf8′);
//define(‘DB_COLLATE’, ”);

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.

utf-8-database-converter

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.

Did you enjoy this article?
Signup today and receive free updates straight in your inbox. We will never share or sell your email address.

3 Comments

  1. oh vow, nice 2 c a niche blog from u for wordpress. wish u good luck, mayu. let me try this plugin later

    Reply
  2. @Ravishankar
    Thanks Ravi, you are the first to comment in this new blog!

    Reply

Leave a Reply