If you have installed Wordpress 2.5 with Fantastico, probably you can notice a wrong charset of russian or other text in Wordpress. How to fix wrong charset?
Check main configuration of Wordpress in wp-config.php. You should have these records:
define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');
Open your PhpMyAdmin and check settings for default charset and collation.
Set collation as utf8_general_ci
- MySQL charset: UTF-8 Unicode (utf8)
Let’s check settings for the tables. You can see that all tables have not utf8 charset, but latin or any other chrset your hosting can imagine :-), but default collation for the database is utf8 already.
Next step - Export Wordpress database and fix collation and charset for all records.

Press Export button, select “Save as file” in checkbox and press “Go“.
Now you should be able to download copy of your database. Save it and open in any text editor like notepad. Search and replace all latin1 (or your current charset) to utf8.
Upload file with Import button. If your hosting is good enough, now you should be able to make posts in your native language.
Troubleshooting:
Error for import tables or database - tables or database already exist
Press Drop button and selected database will be deleted (careful here :-)) Now try to import database once again.
If your hosting decide to delete Drop button from your phpmyadmin (just like my phpadmin here don’t have it), then you can delete tables in this way:
Open database (Browse) and select all tables. Select Drop from menu.
Also maybe you should delete this line in your edited copy of the database:
CREATE DATABASE `your_database_name` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
It’s highly recommended to leave this line in a file
USE `your_database_name`;
I hope this small tutorial will help you.
Good Luck! ![]()


