Hi, This feature is still not available after 7 years. Its still in roadmap for 1.4.x.
When is the 1.4.x release with ENUM supported? On Thursday, 10 January 2008 02:18:54 UTC+5:30, Thomas Mueller wrote: > > Hi, > > I have added a feature request > (http://groups.google.com/group/h2-database/web/roadmap, Support ENUM > data type), but it will take a while until this is implemented. > > A workaround is using this construct: > > create table test(id int primary key, status varchar not null default > 'Current' check status in ('Current', 'Lapsed', 'Unknown')); > insert into test values(1, default); > > Or using a user defined data type (domain): > > create domain status as varchar not null default 'Current' check value > in ('Current', 'Lapsed', 'Unknown'); > create table test(id int primary key, status status); > > Regards, > Thomas > > > On Jan 8, 2008 11:19 AM, jay019 <[email protected] <javascript:>> wrote: > > > > Hi all, > > > > Just wondering if there is an equivalent column type to the 'ENUM' > > column type in MySQL? > > In MySQL I have a column like... > > `status` enum('Current','Lapsed','Unknown') NOT NULL default 'Current' > > and I can't work out how to do something similar in H2. > > > > It's probably something simple that I am overlooking. > > > > Thanks in advance. > > > > Jay > > > > > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
