Which parameter causes ENUM to be unavailable in MySQL Workbench?

Question

I'm trying to do a simple thing: add a column with the ENUM data type in the MySQL Workbench model. The problem is that there is simply no choice. I can not select "ENUM".

If I open an old project or create a new one in the same Workbench, I have a choice, so it seems to be a setting, but I don’t know where to look. This is not some SQL thing, because the export and import (reverse engineer) in the new model also shows ENUM columns.

To be clear: it is NOT that I type in something like enum(choice,choice2) and therefore generate a syntax error, the drop-down menu does not have ENUM .

Tested:

• Mysql Workbench Version: 5.2.47 CE (Version 10398) on Windows 7
• Mysql Workbench Version: 5.2.40 (Revision 8790) on Ubuntu 13.04
• Mysql Workbench Version: 6.0 (Build 6.0.3.11035) (BETA) on Windows 7

The settings for all projects are the same ("default"), in my case

• Standard mysql target version: 5.5
• Storage Engine: InnoDB
• SQL_MODE to use: TRADITIONAL,ALLOW_INVALID_DATES

It looks like there are a few missing types:

• Bit
• ENUM ()
• SET ()

Answer 1

I now consider this an official “mistake”, and therefore there will be no real solution. The only thing you can do is start a new model and re-create all your work there.