ENUM columns and blank values

[Tom Byars]

You can't make one of the enum choices ''. You can't give an enum field a default value of ''. You can't UPDATE an enum field to ''. You can't UPDATE an enum field to have value 0. You can't give an enum field a default value of 0.

You can edit a table with an enum field in the query browser and set the enum field to 0 and that gives the field a value of ''.

Whoever's responsible for the design of enum fields missed his vocation in life. They should've been designing puzzle books.



Edited 1 time(s). Last edit at 03/05/2009 04:08AM by Tom Byars.