Re: Setting the MySQL client character set

2006-04-13 Thread Peter J. Holzer
On 2006-04-12 13:25:49 -0500, Paul DuBois wrote: > On 4/12/06 13:03, "Peter J. Holzer" <[EMAIL PROTECTED]> wrote: > > 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 characte

Re: Setting the MySQL client character set

2006-04-12 Thread Ron Savage
On Wed, 12 Apr 2006 20:03:35 +0200, Peter J. Holzer wrote: Hi Peter > 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. Geez. Congratulations on your great detective work! -- Cheers Ro

Re: Setting the MySQL client character set

2006-04-12 Thread Paul DuBois
On 4/12/06 13:03, "Peter J. Holzer" <[EMAIL PROTECTED]> wrote: > 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'"); How does the re

Setting the MySQL client character set

2006-04-12 Thread Peter J. Holzer
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 the