Character Sets in PHP + MySQL

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
Can anyone advise me on the use of UTF-8 in PHP and MySQL? What is the best  

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

Kevin Laurence wrote:
Quoted text here. Click to load it
Are you sending a header which tells the browser you will be sending it  
UTF-8 ?
    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"  />

Re: Character Sets in PHP + MySQL

Yes. The response header includes 'Content-Type: text/html; charset=utf-8'.

Quoted text here. Click to load it

Site Timeline