Re: FN-FORUM: Problem with =?UTF-8?B?wqM=?= sign encoding

date posted 1st December 2005 09:05

>I'm getting data from mysql and displaying it with php in an html =
page
>encoded to iso-8859-1. On my local server =C2=A3 signs display fine but on =
my
>live server they display as A=C2=A3.

Is your live server serving the pages as UTF-8 and your test server =
ISO-8859-1? Or the other way round? Opera's Info pane (and probably =
something in FireFox) will tell you.

Also check the MySQL connection charset, you might need to change the =
default on one server, or use SET NAMES UTF-8 or SET NAMES ISO-8859-1 =
before performing any queries. That was the fix I needed when I had this =
type of problem.

Collations are to do with alphabetic sorting, and only related to character =
sets.

Hope this helps...

Anthony
--
www.fonant.com - hand-crafted web sites