Subject RE: [firebird-support] MySQL Enum type?
Author Sasha
> > Does Firebird have something like the MySQL Enum datatype?
> or is there
> > a workaround?
>
> Luckily, it does not :-)
>

I agree, luckily no enums. But if I have understood mysql docs on the
subject enums are just a subset of check constraint.
So, if you want for example a column that accepts only 'one', 'two', 'three'
as values you can define domain as follows:

create domain numbers as
char(5) not null
check (value in ('one', 'two', 'three'));

and use it as needed.
Of course, you don't need to create a domain, you can define a check
constraint on a table.

Sasha