Christophe Chisogne wrote:

Christophe Chisogne wrote:

> Likely an encoding problem : latin1 (iso-8859-1) vs Unicode (utf-8)
> 
> Check display diffs with display/encoding menu on firefox
> -- french Affichage/Encodage des caractères

Yeah, I checked that. The very same Firefox is working fine with the data on
the shared hosting, but not with my local system. To pin this down, I spent
some time getting the existing site (ie, the one currently working on the
shared hosting) working on my local system (wasn't easy, because I've made
loads of changes to tables for the new version of the site). The result?
Garbled characters. So - the exact same PHP code, MySQL tables and browser
work with the shared hosting but not the local system. I knew upgrading to
SuSE 9.1 was going to give me grief :-)

And that brings me to:

> You can use the mozilla/firefox livehttpheaders tool [8] to check
> which encoding is used by the Apache server. Shoud be latin1/iso-8859-1,
> not utf-8, utf-16 etc
> 
> Avoid pblms by
> 
> - telling mysql server to use latin1 encoding

I'd come to the conclusion it must be a problem in my Apache/PHP/MySQL
setup, as that's the only difference between the two cases. So looks like
it's not a PHP issue after all - so sorry about the wasted bandwidth.

That said, MySQL is already configured to use latin1 and Apache2 seems to be
set to iso-8859-1 (according to /etc/apache2/mod_mime-defaults.conf - can't
find another config file with any encoding setting). Hmmm.

> - Better html code in (generated?) html, like this
>    <meta http-equiv="Content-Type" content="text/html;
>    charset=iso-8859-1">

Already do that, though I tend to use iso-8859-15, which I understand is
pretty much the same with added euro support.

So, merci bien for a very useful response - I've printed it so I can go
through all the things you suggest. Much appreciated.

-- 
@+
Steve

-- 
PHP Internationalization Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to