I would like to go ahead and update my install but my current database seems to have characters encoding issues :
- all my options (header, meta, RSS) are set to UTF8
- the database tables and fields are latin1
- as a result, the data stored in the DB look like this in phpmyadmin :
je suis allàƒÂ© chez AmàƒÂ©lie
instead of :
je suis allé chez Amélie
What would be the best way to set all the data in UTF8 ? I saw g3org3x's plugin but it only modifies the DB structure. I would like to do the data as well.