This just cost me a few hours of debugging, so I am posting it to spare others:
The mysql client character set can be set to UTF-8 with:
$dbh->do("set character set utf8");
$dbh->do("set names 'utf8'");
That's in the manual. What is not in the manual is that the order is
crucial. If you swap them, it does not work, and you will get very
strange results.
hp
--
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | [EMAIL PROTECTED] | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users
pgpcmJ7bLZ0e1.pgp
Description: PGP signature
