Character Sets in PHP + MySQL

[Kevin Laurence]

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?

[Juliette]

Kevin Laurence wrote:

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?

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" />

[Kevin Laurence]

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

"Juliette" <jr*********@jokeaday.net> wrote in message
news:43***********************@news.wanadoo.nl...

Kevin Laurence wrote:

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?

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" />