| Bug #43352 | Collation for ENUM type not possible | ||
|---|---|---|---|
| Submitted: | 4 Mar 2009 8:29 | Modified: | 7 Aug 2009 15:07 |
| Reporter: | Håkan Askengren | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Workbench | Severity: | S3 (Non-critical) |
| Version: | 5.0.30 OSS | OS: | Windows (XP) |
| Assigned to: | Alfredo Kojima | CPU Architecture: | Any |
| Tags: | character set, CHECKED, collation, enum | ||
[5 Mar 2009 12:13]
Valeriy Kravchuk
Indeed, we can set collation for ENUM in MySQL server. See http://dev.mysql.com/doc/refman/5.1/en/enum.html also. So, Workbench should provide some means to do that.
[6 Aug 2009 18:02]
Johannes Taxacher
this has been added. setting collation for enum columns will be available in 5.1.17
[7 Aug 2009 15:07]
Tony Bedford
An entry was added to the 5.1.17 changelog: In the Columns tab of the Table Editor, when setting a column datatype to ENUM it was not possible to choose Collation for the column details. Only the Table Default collation was available.
Description: In table editor, column tab When having datatype ENUM it is not possible to choose collation for column details. Only table default collation is possible. (Need "CHARACTER SET ascii BINARY" for an ENUM type in an UTF8 table) How to repeat: As above Suggested fix: If as mysql documentation: ENUM('value1','value2',...) [CHARACTER SET charset_name] [COLLATE collation_name] open up for fix collation for ENUM type.