|Subject||RE: [firebird-support] MySQL Enum type?|
> > Does Firebird have something like the MySQL Enum datatype?I agree, luckily no enums. But if I have understood mysql docs on the
> or is there
> > a workaround?
> Luckily, it does not :-)
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.