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.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!