When creating WordPress pages and posts you are not confined to use only the English language and character set. In fact, any language can be used and in Cyprus, even if the majority of our reader do understand and speak English, sometimes you’d prefer publishing your content in Greek. Sometimes after a database update things may have gone wrong and your site becomes unreadable.
When your Greek text in WordPress shows suddenly all garbled and unreadable there is Character Encoding Mismatch issue.
How to Fix a character encoding mismatch problem in WordPress
1) You need to edit the ‘wp-config.php’ file. Either use your online editor or open the ‘wp-config.php’ file in a separate text editor such as notepad (the wp-config.php file can be found in the root directory of your WordPress installation). It is always a good idea to first make a backup of the file.
2) Locate the following two lines and comment them out:
define('DB_CHARSET', 'utf8'); define('DB_COLLATE', '');
After you commented them out, they should look like :
//define('DB_CHARSET', 'utf8'); //define('DB_COLLATE', '');
Step 3) Now upload (or save if you use your online editor) the updated ‘wp-config.php’ file to your hosting platform (overwriting the old wp-config.php file, but keep the back, just in case….).
Character encoding problems can happen after a database upgrade or other interventions on the site (plugins, etc….).