How to fix accented character substitutions on French text in MySQL db
After you connect to MySQL in PHP OR in HeidiSQL, use SET NAMES 'utf8'. This is effectively equivalent to:

SET character_set_client = utf8;

SET character_set_results = utf8;

SET character_set_connection = utf8;

Now try your insert statement containing French characters.