Columns can have character set definitions, also. In this case, I hope not.
Regards, 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: 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" > > 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 default to use > when creating > new tables. As far as adjusting every single table, you can > work with > your Favorite Scripting Program (tm) and run the query: > > `SHOW TABLES` > > to get a list of all tables for that database (the column you want is > called Tables_in_[database name here]), which you can get the exact > column by running it in console or your Favorite SQL Program > (tm). Then > simply loop over the result set and run the alter table > command on each > table. > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]