CORRECTION - Re: [ILUG] Editing unicode text files.
kae at verens.com
Sun Feb 18 11:47:33 GMT 2007
Niall O Broin wrote:
> My personal current fight with this with a PHP4 site which I'm trying
> to migrate
> off a RHEL 3 box, with a 3.23.xx version of MySQL. There is a small
> number of
> characters used which are non ASCII (the German ones with umlauts and
> the sz beta
> character) and for the life of me, I cannot persuade those to display
> correctly on
> the new site, no matter what magic options I use to dump and restore
> the DB.
probably because the PHP4 bindings to MySQL are all ISO8859-1 encoded,
if I remember correctly - even if your PHP outputs in UTF-8, and the
MySQL tables and server have been told to speak only in UTF-8 mode.
for PHP, try to use the MySQLi extension instead of the MySQL extension,
as MySQLi is UTF-8 by default (IIRC). Dunno if they're available for
PHP4, but if so, use them.
and yes - mine-field. I don't like even thinking about it.
More information about the ILUG