CODEWITHSUNDEEP
phpmysqlutf-8
Rider
Rider

Reputation: 1003

How to Inserting french characters in mySQL DB table?

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?

Upvotes: 1

Views: 7148

Answers (3)

Peter Kiss
Peter Kiss

Reputation: 9329

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 )

Upvotes: 2

Roberto
Roberto

Reputation: 528

In the php:

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

After connection:

mysql_set_charset("utf8");

Upvotes: 7

Qian
Qian

Reputation: 1027

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

Upvotes: 0

Related Questions