ENUM columns and blank values
Posted by:
Tom Byars
Date: March 05, 2009 04:07AM
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.
Subject
Written By
Posted
ENUM columns and blank values
March 05, 2009 04:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.