Re: FN-FORUM: UTF-8 problem

date posted 18th September 2007 14:02

Hi Steve,

> I have a UTF-8 problem, the pages on http://ambulancia.beyondss.com are
> correctly set to charset=3Dutf-8 as are the files, (utf-8 characters such
> as =E1=E9=ED=F4=FA are displayed in the browser correctly, however if you=
click
> this link, http://ambulancia.beyondss.com/news/3/Hotel+most+Slavy . The
> text is retrieved from a mysql table, which stores the data as
> utf8_general_ci. I have checked the data using PHP MyAdmin, and the
> characters are stored correctly. Any suggestions?

It looks like you have two problems here. The text from the DB isn't being=
=20
sent as UTF-8 to the browser (looks more like an ISO-8859 encoding), and it=
=20
appears it's been transliterated to a destination encoding that doesn't=20
include all of the original characters (hence the question marks).

Are you absolutely sure the text in the DB is stored as proper UTF-8?=20
Secondly, are you setting the connection character set properly before=20
issuing queries?

You might want to have a look here:=20
http://www.byteflex.co.uk/fun_with_utf8_php_and_mysql.html

Cheers,
Neil