Jerry Schwartz
>> Global Information Incorporated
>> 195 Farmington Ave.
>> Farmington, CT 06032
>>
>> 860.674.8796 / FAX: 860.674.8341
>>
>>
>>> -Original Message-
>>> From: Chris White [mailto:[EMAIL PROTECTED]
>>> Sent: Wedne
ECTED]
Cc: mysql@lists.mysql.com
Subject: Re: automated character set conversions for tables
> I did a DB conversion before that with "ALTER DATABASE db_name
> CHARACTER SET utf8"
> That worked wonderfully, except not as expected. ;-)
> It basically converted only the database itself. so
> Sent: Wednesday, January 10, 2007 10:59 AM
> To: [EMAIL PROTECTED]
> Cc: mysql@lists.mysql.com
> Subject: Re: automated character set conversions for tables
>
>
> > I did a DB conversion before that with "ALTER DATABASE db_name
> > CHARACTER SET utf8"
>
I did a DB conversion before that with "ALTER DATABASE db_name
CHARACTER SET utf8"
That worked wonderfully, except not as expected. ;-)
It basically converted only the database itself. so I had to do a
separate "ALTER TABLE ..." for each table.
The database encoding more establishes the defa
