Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- Character Sets in PHP + MySQL
- Kevin Laurence
December 1, 2005, 8:01 pm
rate this thread
I would prefer to store HTML extended characters in the database as UTF-8,
but I can only get the HTML to display properly if I store character
entities (eg. ř).
Every table in my database is set to UTF-8. The web page generated by PHP is
declared as UTF-8. The HTTP response header from the server is UTF-8. The
character set of the database connection is defined as UTF-8.
I've tried using the PHP function "htmlentities" to convert the characters,
but it doesn't work for the complete UTF-8 character set.
What am I missing? Do I need to do something with the Multibyte string
Re: Character Sets in PHP + MySQL
Are you sending a header which tells the browser you will be sending it
header('Content-Type: text/html; charset=utf-8');
In the HTML you could also add:
<meta http-equiv="Charset" content="UTF-8" />
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />