How to Inserting french characters in mySQL DB table?

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?

the problem is the accents characters are not UTF-8 by default, they are iso-8859-1. how do you see the results from mysql ? (a terminal connect to mysql using mysql client ? a web page) — ajreal, Feb 27 '12 at 17:51

score 7 · Accepted Answer · answered Feb 27 '12 at 17:51

7

In the php:

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

After connection:

mysql_set_charset("utf8");

answered Feb 27 '12 at 17:51

Roberto

528
7
15

1

It worked by giving mysql_set_charset("utf8"); after connection – Rider Mar 01 '12 at 02:33

score 2 · Answer 2 · answered Feb 27 '12 at 17:52

2

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 )

answered Feb 27 '12 at 17:52

Peter Kiss

9,309
2
23
38

score 0 · Answer 3 · answered Feb 27 '12 at 17:50

0

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

answered Feb 27 '12 at 17:50

Qian

1,007
7
6

How to Inserting french characters in mySQL DB table?

3 Answers3

Linked