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

[11 Nov 2004 9:01] Stefan Wurzinger
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
[8 Jun 2005 15:53] Michael G. Zinner
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/