Yesterday I tried to upgrade a friends wordpress after succesfully upgraded my own. Instead of seeing the page that is was all a piece of cake something went wrong. Loking at the database in phpmyadmin told me that the tables couldn't be repaired. No problem I thought, just restore the backup. That was no help and now I have made a new, fresh install of wp 2.0.9. cut the database sql file into little pieces en restored the database. WordPress is working again but..... in Holland we have this accents on letters, like á en é, and also the quotesignes. They are all replaced by other characters and combination of characters. I know now (after a lot of reading and googling) that his has something to do with the charset. In the table it is said that it is set on latin_1_ci, but in the header of the page its utf8.
I've tried to change, but I think the problem now is the restore of the database. That exporting went wrong. So I want to replace all this funny characters with the proper html-code. If that is possible. I was thinking of a query in phpmyadmin, but don't know much about that and looking on the internet didn't bring me de right string.
How can I change this characters by a sort of search and replace order?
Of is there a better way to solve this problem