MySQL Bugs: #70154: Table editor collation drop-down menu not working properly

Bug #70154	Table editor collation drop-down menu not working properly
Submitted:	26 Aug 2013 16:47	Modified:	18 Dec 2013 15:01
Reporter:	Karl Nicoletti	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S2 (Serious)
Version:	6.0.6	OS:	Windows (Windows 7 64bit)
Assigned to:		CPU Architecture:	Any
Tags:	collation, table editor

Description:
Selecting a different collation from the "Schema Default" drop down menu button in the Table Edit->Options screen does not set the option.

Need this ability because on some tables we want to force default character set to something other than than UTF8. To work around this I have to hand-edit the forward-engineered DDL file and place the statement "DEFAULT CHARSET = big_5" after the "ENGINE = InnoDB" at the end of the table DDL.

How to repeat:
1) Create a new table.
2) Double-click to display the table editor.
3) Click the "Options" tab at the bottom.
4) Click on the double down-arrow in the upper-right corner of the panel
5) Set the "Collation:" by clicking on the "Schema Default" button
6) Pick any collation other than the default.
7) The "Schema Default" button will very, very briefly change to your selection, but then will switch back to "Schema Default".
8) If you "Copy SQL to Clipboard" from the context menu, there is no default collation ever define in the table definition SQL.

Thank you for the bug report.

This is a duplicate of bug #68672