=?UTF-8?Q?RE:_FN-FORUM:_Problem_with_=C2=A3_sign_encoding?=

date posted 1st December 2005 12:42

Excellent, thanks for that Anthony.

> 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=20
> any queries. That was the fix I needed when I had this type of =
problem.

I'm sure the above is a good solution but I'm still no nearer sorting it =
as it seems my client is running MySQL 4.0.20-standard whereas I run =
nothing older than MySQL 4.1.10 and it seems there were some major =
changes in CHARACTER SET handling between the two. For instance, 'SET =
NAMES latin1' works fine on >=3D 4.1 but gives #1193 - Unknown system =
variable 'NAMES' on v4.0x. :-(

Anyway, I'll keep trying... I really, _really_ don't want to have to =
re-encode all the data and output all my pages in a different character =
set.

Ben