Incorrect encoding when data read from a mysql database

Hi,
I am designing a website that requires storing data in 3 different languages,
English, Portuguese and Tetum.

When I read the data from the database the accented characters are displayed
as a ? in Firefox and Opera, a square in IE and correctly in Chrome

How can I convert it on the fly and display the data correctly?

Thanks for the help
Neil

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Incorrect encoding when data read from a mysql database

On Fri, Dec 3, 2010 at 4:42 AM, Neil Jackson wrote:
> Hi,
> I am designing a website that requires storing data in 3 different languages,
> English, Portuguese and Tetum.
>
> When I read the data from the database the accented characters are displayed
> as a ? in Firefox and Opera, a square in IE and correctly in Chrome
>
> How can I convert it on the fly and display the data correctly?
>
> Thanks for the help
> Neil
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

1. set the db to store unicode characters
2. send the html with a utf-8 character header

--

Bastien

Cat, the other other white meat

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php