Pufak on "Wordpress Database or Network Repair and Fix"

You probably want to make sure you use the same collation and char-set for every table.

I would recommend you change the line in your wp-config.php to:

define ( 'DB_CHARSET', 'utf8');

and add a collation:

define ( 'DB_COLLATE', 'utf8_unicode_ci');

Then once you have done this, set the default character-set and collation for your database using the following SQL Query:

ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;

You should replace the word databasename with your actual database name.

Then after you have done that - you will need to change the collation and character-set on every table in the database to match. This will convert the tables to use the same character-set and collation:

ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci;

Again, change tablename to the name of every table that you wish to change.

Needless to say, you need to make a backup before you do any of this to your database.

At this point everything in your database should be converted to UTF8 as well, and things should start to be interpreted correctly.