How to Inserting french characters in mySQL DB tab

Question

I am having a major issue with inserting french characters in my mySQL DB. The french charaters doesn't display properly in the mysql table. For example "Éducation" is displayed as "Éducation". I have set the encoding to utf8_unicode_ci. I have also tried the function htmlentities($string ,ENT_QUOTES, "UTF-8"). Can someone help me with this?

Answer 1

Please check these:

• Database encoding
• Table encoding
• Field encoding
• Database connection encoding
• PHP runtime encoding
• .php and other files encoding
• Header encoding (HTTP header and/or HTML )

Answer 2

first check the encoding of the table, then check the encoding of the insert.

Answer 3

In the php:

header ('Content-type: text/html; charset=utf-8');

After connection:

mysql_set_charset("utf8");