How to Fix the Character Encoding Problem in WordPress

Categories: Wordpress

I recently changed my web hosting again in an attempt to speed up the page load time of my website. I had to do it as the former hosting’s page response time was horrible. It was taking 9 seconds for my home page to load with the former hosting. Now my home page loads under 4 seconds! It’s amazing the difference it makes… now I don’t get angry when browsing my own site (I wonder what my visitors were thinking while waiting for the page to load!).

Anyway, The transfer was smooth but I had a slight issue that I noticed after the transfer. There were special characters similar to the following scattered throughout my blog posts:

special-char-example

I was pretty sure that this was a character encoding mismatch problem. I got a little scared thinking it would take a long time to fix but then I found a really easy way to solve it.

code-encoding-icon-275

Fixing the Character Encoding Mismatch Problem in WordPress

  • Open the ‘wp-config.php’ file in a text editor such as notepad (the wp-config.php file can be found on the directory where you installed WordPress).
  • Find the following two lines and comment them out:
define(‘DB_CHARSET’, ‘utf8′);
define(‘DB_COLLATE’, ”);

They should look like the following after you comment them out:

//define(‘DB_CHARSET’, ‘utf8′);
//define(‘DB_COLLATE’, ”);
  • Now upload the updated ‘wp-config.php’ file to your webhost.

This character encoding problem can happen after a database upgrade too so it doesn’t hurt to keep this trick in your mind just in case.

Articles you may also like:

  1. How to Install WordPress on Your Blog (Instructions with Screenshots)
  2. How to import WordPress SQL database backup file without having ‘create new database’ privileges in phpMyAdmin
  3. How to Uninstall and Reinstall WordPress
  4. WordPress Optimization Tips and Tricks for Better Performance and Speed
  5. How to fix WordPress.com Stats plugin showing zero (0) visitors!
Tags: , , ,

Subscribe to Tips and Tricks HQ to stay informed

twitter_icon

15 Responses.

  • #1 by Dave on January 25, 2012 - 1:35 pm

    THANK YOU! We actually needed to ADD “define( ‘DB_CHARSET’, ‘utf8′);” IN on the wp-config file when we had this issue moving from Dreamhost to Hostgator. But it worked like a charm on a 500+ page website. This literally saved us dozens of hours.

  • #2 by Vitaliy on December 22, 2011 - 6:20 pm

    Thank you for saving me a TON of time. This helped me out after a DB restoration,

  • #3 by Raphael Oliveira on November 4, 2011 - 2:55 pm

    You´ve just saved my blog! Transfered to another server. Thank you.

  • #4 by Dragan Đermanović on August 17, 2011 - 7:21 pm

    I had similar problem during some plugin fixing but unfortunately this was not solution for my problem.

    Apparently it was not up to db charset/collation but symptoms were just the same…

    BUT (in case someone is in the same jam):
    have opened file in Dreamweaver –> checked out if encoding is unicode utf-8, ok –> Save As with checked “Include Unicode Signature (BOM)” in the Save As dialog and ta-daaa!!!

  • #5 by Charlotte Coleman on April 12, 2011 - 12:24 pm

    Thanks a lot – this issue has been investigated by the hosting company for 3 weeks to no avail. I thought I’d take a quick look myself and found your post. Really helpful!

  • #6 by Technology Resources on February 17, 2011 - 2:53 am

    Awesome man,You have saved me from getting fired. I have been struggling with this character encoding problem since many days. Thanks alot.

  • #7 by location voiture Casablanca on February 1, 2011 - 9:45 pm

    thank you very much for this soluttion, but i find only line :

    define(‘DB_CHARSET’, ‘utf8′);

    and i remplaces with

    define(‘DB_CHARSET’, ‘utf8′);

    and that’s work ^^

    thank you

  • #8 by Jessi on January 13, 2011 - 5:43 am

    THANK YOU!!!!!!!!!!!!!!!! I’ve been struggling with this for over a year with one of my wordpress sites and your post is the first and only simple solution….that worked! Thank you so much!

  • #9 by Jesper Wilfing on May 24, 2010 - 4:36 am

    Aight.. I managed to solve this by changing the coding of the PHP pages themself with notepad++:
    http://wordpress.org/support/topic/401149?replies=2

  • #10 by Jesper on May 19, 2010 - 3:54 am

    Arghh.. it didn’t help me… I still gret ����� characters instead of É´å ä ö … Really anoying. Any ideas? Source of the text is both from database and from pages.

    /Jesper

  • #11 by admin on July 16, 2009 - 8:36 pm

    Hi Charles, I switched to InMotion Hosting. Yeah so far I am happy with them. I really hate it when a webhosting company puts you on an overpopulated server and your site runs like a dog.

  • #12 by Charles on July 16, 2009 - 1:28 pm

    What web host did you switch to?
    Your site is indeed faster now and I’m sure the web host plays a role.

    best,
    Charles

  • #13 by George Serradinho on July 6, 2009 - 10:41 am

    I had that once when I backed up my database and then had to reload it as it was corrupt. At that stage I had a few posts so I actually ended up edit the posts one by one.

    I will remember this tip if it happens again.

Featured & Popular Articles

Tips and Tricks Hot Items

wordpress estore plugin
wordpress membership plugin
WordPress PDF Stamper Plugin
WordPress Lightbox Ultimate Plugin
WordPress Affiliate Link Manager Plugin
wordpress affiliate plugin