Background Knowledge
The MySQL
database v4.0.23 is using the default character set of
“Latin1″. When the database was created I had no knowledge of
character sets other wise it would have been
“UTF-8″.
The web pages are using a character set of “UTF-8″.
Problem
Data being queried from a MySQL database that contains French accent characters will not render correctly in the browser even after applying PHP htmlentities().
Example code: $string = htmlentities($string , ENT_QUOTES, “UTF-8″);
Solution
The queried data from the database was inputted using the character set “ISO-8859-1″. I …
[Read more]