I messed up the settings with W3 Total Cache (tried to import all the media to my library, didn't work out well, broke all my links to every picture). So I took my latest backup of the database, copy/paste the _post and _postmeta tables inside my phpmyadmin. It brought back the links and pictures as expected, but now all the french characters (à,é,è etc) are not displayed properly.
I took the backup from the plugin WP-DBManager, which doesn't seem to handle UTF-8 properly. What's the fastest way to correct the issue ?
Edited for more details: The SQL backup header is
DROP TABLE IF EXISTS `hojd_posts`; SET @saved_cs_client = @@character_set_client; SET character_set_client = utf8;
However I have those characters badly encoded coming directly in my sql commands (eg: franÃ§ais for "français")...