| re: Character Sets in PHP + MySQL
Kevin Laurence wrote:[color=blue]
> Can anyone advise me on the use of UTF-8 in PHP and MySQL? What is the best
> approach?
>
> 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
> functions?
>
>[/color]
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" />
| 
