MySQL Bugs: #6571: alter table with Default as character set

Bug #6571	alter table with Default as character set
Submitted:	11 Nov 2004 9:01	Modified:	8 Jun 2005 15:53
Reporter:	Stefan Wurzinger	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Administrator	Severity:	S3 (Non-critical)
Version:	1.0.14	OS:	Windows (Windows XP Prof. SP 1)
Assigned to:	Michael G. Zinner	CPU Architecture:	Any

Description:
Hi!

If I want to change the character set of a table to Default via MySQL Administrator Table Editor, I will get an error, because the alter syntax is wrong.

The popup displays following wrong syntax:
ALTER TABLE `databasename`.`tablename` OLLATE Default;

The syntax should be:
ALTER TABLE `databasename`.`tablename` CHARACTER SET Default COLLATE Default;

I think you know :-)
By the way I'm using MySQL 4.1.7 with mysqld-nt and MySQL Administrator 1.0.14.

Greetings

Stefan

How to repeat:
Open MySQL Administrator 1.0.14 - connect to the database - choose a database from the catalogs - double click on a table - the mysql table editor pops up - go to the table options tab  - go to the character set section and choose Default as character set - hit the apply button - now the popup shows you a wrong syntax - hitting execute will produce an error.

Suggested fix:
please correct the synatx :-) 

Thanks.

Greetings

Stefan

Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/