Scpecial Chars - 'Ãi' to 'á' - charset

[JoeAley2003]

Hi all...

I have a sql table that contains files saved with special chars i
think, for example, 'AmapÃi', where we expect 'Amapá'.

When i debug my var on phped, i see 'Amapá' and when i look at any
browser, netscape or IE i see 'AmapÃi'.

Anybody have a hint??? I don't know what to do...
Thank you all!!!

[Daniel Tryba]

JoeAley2003 <jo*********@yahoo.com> wrote:

When i debug my var on phped, i see 'Amap?' and when i look at any
browser, netscape or IE i see 'Amap?i'.

The first ? is an iso-8859-1 character, the second one is utf-8 encoded.

If you'll send the proper content-type (charset=utf-8), your problem
will propably dissapear.

But best would be to figure out what you are really storing in the db!
Maybe you're seeing the information you expect in phped because that is
unicode aware, else some one/thing is translating out input/output
(mbstring of iconv could be doing that).

--

Daniel Tryba

[Chung Leong]

The second string is not proper utf8 text, since the high-order bit of the
second byte isn't set. Hopefully it's conversion problem in posting to the
newsgroup. Otherwise, Mr. JoeAley is looking at a database full of corrupted
data.

Uzytkownik "Daniel Tryba" <ne****************@canopus.nl> napisal w
wiadomosci news:c3**********@news.tue.nl...

JoeAley2003 <jo*********@yahoo.com> wrote:

When i debug my var on phped, i see 'Amap?' and when i look at any
browser, netscape or IE i see 'Amap?i'.

The first ? is an iso-8859-1 character, the second one is utf-8 encoded.

If you'll send the proper content-type (charset=utf-8), your problem
will propably dissapear.

But best would be to figure out what you are really storing in the db!
Maybe you're seeing the information you expect in phped because that is
unicode aware, else some one/thing is translating out input/output
(mbstring of iconv could be doing that).

--

Daniel Tryba