CORRECTION - Re: [ILUG] Editing unicode text files.

[Kae Verens]

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.

UTF-32??? *shudder*

Kae