Hi. I have a problem with my wordpress based weblog at http://mundogeek.net and I would be thankful for any help you could give me to solve it.
I'm trying to move my current database to dreamhost but I have problems with the character encoding.
They have MySQL 4.1.15 at my previous host, and I used phpMyAdmin 2.6.0-pl3 to make the backup.
phpMyAdmin says the MySQL charset is UTF-8 Unicode (utf8) and MySQL connection collation utf8_general_ci.
Then, on the tables of the database it says the collation is latin1_swedish_ci. Don't know why.
If I open, say, wp_posts in phpMyAdmin with UTF8 as charset selected in the browser, I see some strange characters instead of accents and the spanish special characters. So I don't know if the charset is truly UTF8, but WordPress options are set to use UTF8 and when I open my weblog it seems to be okay.
Then I copied all my files to dreamhost and used 'source dump.sql' at the mysql command line to import the backup into the new database.
Dreamhost seems to use MySQL 4.1.14 with phpMyAdmin 2.6.4-pl3. MySQL charset is UTF-8 Unicode (utf8) and MySQL connection collation utf8_general_ci, as in my previous host.
When I open my weblog now that I moved to dreamhost I see strange characters. And if I open phpMyAdmin I see strange characters too, but they are not the same as the ones I saw when I opened phpMyAdmin in my previous host. For example where "espÃa" (spy) should be readed I see "espÃƒÆ’Ã‚a" in Dreamhost's phpMyAdmin and "espÃƒa" in my previous host.
So, please, do anybody know some reason for this to happen? Can this be a wordpress bug? MySQL's? a collation problem? some mistake I made?
Thank you so much