Bug #38681 Changing a table's charset and collation to 'binary' gives an error
Submitted: 8 Aug 2008 20:37 Modified: 14 May 2009 12:32
Reporter: Federico Razzoli (OCA) Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Query Browser Severity:S3 (Non-critical)
Version:1.2.12 OS:Linux (Ubuntu 8.04)
Assigned to: CPU Architecture:Any

[8 Aug 2008 20:37] Federico Razzoli
Description:
If you edit an existing table with the table editor and try to change its default charset to Binary pseudo charset and its default collation to binary, the editor generates a wrong query:

ALTER TABLE `db`.`table` CHARACTER SET binary COLLATE binary;

It returns the error 1064.
You have to manually edit the query. The following query (which uses 'quotes') seems to be correct:

ALTER TABLE `db`.`table` CHARACTER SET 'binary' COLLATE 'binary';

How to repeat:
Edit an existing table with table editor.
Change default charset to binary AND default collation to binary.
[8 Aug 2008 21:29] MySQL Verification Team
Thank you for the bug report.
[14 May 2009 12:32] Susanne Ebrecht
Many thanks for writing a bug report. We are on the way to implement full functionality of MySQL Query Browser into MySQL Workbench. Unfortunately you are using an unsupported platform. More informations about supported platforms you will find here:

http://www.mysql.com/support/supportedplatforms/tools.html

More informations about MySQL Workbench you will find here:

http://dev.mysql.com/workbench/