MySQL Bugs: #20990: MYSQL VISUAL WORKBENCH CHARACTER SET COLLATE NULL ON VARCHAR

Bug #20990	MYSQL VISUAL WORKBENCH CHARACTER SET COLLATE NULL ON VARCHAR
Submitted:	12 Jul 2006 9:48	Modified:	12 Jul 2006 14:28
Reporter:	Steve Pratt	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Workbench Preview	Severity:	S2 (Serious)
Version:	1.1.1 alpha	OS:	Windows (Windows)
Assigned to:		CPU Architecture:	Any

Description:
When creating a model and generating the resultant script the varchar type is not setting character set and collate strings which are required for the sql script to run correctly. Is there a fix for this, as this is causing a real nuisance. the bug was reported also under 19485 for version 1.0.6 beta. The GUI has a field for entering the collate setting but this does not work as well, and or does not allow you to edit.

How to repeat:
Model a table with varchar row.. Then export an sql script easy...

Suggested fix:
Its  a real pain to keep manually editing the sql script for every create statement on round trips.

Thank you for the bug report. Duplicate of bug:
http://bugs.mysql.com/bug.php?id=19485
I will add the version 1.1.1-alpha for the above bug report.