I have a wordpress weblog at http://www.brunotorres.net. Its language is brazilian portuguese and I'm having some troubles trying to migrate it to my new host on dreamhost.
My current database is probably an older mysql version, and it has no 'collation' field on the tables. It is encoded as UTF-8 (If I open it on phpmyadmin with my browser set to utf-8 encoding, all special characters are shown properly). My weblog 'reading' options are set to use UTF-8 on the output.
Well, now I got a new hosting on dreamhost and it seems to use a newer mysql version, with the evil collation field.
I used the one-click installation, which makes things easier and gets the latest wordpress version. I ran the /wp-admin/install.php, all the tables were created with the weird 'latin1_swedish_ci' collation.
So, I went to phpmyadmin on the current server (I have no shell access on it) and exported all the database tables (except wp_options) and imported them on the new server's phpmyadmin. Just to remember, the current database is encoded as UTF-8 and so I did in the new one.
Then, i entered the new wordpress admin interface, set everything up (and set the output charset to UTF-8). But, when I go to the blog, it shows weird symbols instead of the special characters, like Ã© Ã¡ Ã£, used in brazilian portuguese.
I tried to import the database as ISO-8859-1 and it still doesn't work.
The odd thing is that, even my database being encoded as UTF-8, if I set the options to ISO-8859-1, it works properly (ok, you can say, leave it as ISO-8859-1 bu, heck, I want it as UTF-8...it has to work ;) )
Another odd thing is that if I post something from the admin interface, all the special characters are shown properly on the blog, but not on phpmyadmin. I trued utf-8, iso-8859-1, windows-1252 and some other charsets and none of them worked (on phpmyadmin).
So, please, can anyone help me with this? Is this a wordpress bug, a MySQL bug, a collation problem or simply I'm doing the wrong thing?
Any help is appreciated.
PS: If you access http://www.brunotorres.net you'll see everything working, but this is because it's still hosted on the old server. I have to figure out what is happening to be able to migrate to dreamhost.