FN-FORUM: =?iso-8859-1?Q?Problem_with_=A3_sign_encoding?=

date posted 1st December 2005 07:36


Hi

I'm getting data from mysql and displaying it with php in an html page
encoded to iso-8859-1. On my local server £ signs display fine but on my
live server they display as A£. The raw data in both is exactly the same
[e.g. "£22,000k p/a" let's say]. I think I've done everything I should with
regard to encoding but one issue I've noticed is that on my local db my
table has collation set to the default latin1_swedish_ci but on the live db
there is no collation set for the table/field. Can someone suggest...
a] whether this is indeed the problem [which seems likely]
b] how I change collation value using phpMyAdmin if it's not set. I can't
see where to do this as with no collation set I don't even get presented
with the collation dropdown when editing the field. Or is the only way to
edit the sql structure manually?

Thanks in advance.

Ben