>>>>> "Russ" == Russ Southern <russ@stripped> writes:
Russ> According to the manual:
Russ> If you insert an invalid value into an ENUM (that is, a string not present
Russ> in the list of allowed values), the empty string is inserted instead as
Russ> a special error value.
Russ> If an ENUM is declared NULL, NULL is also a legal value for the column, and
Russ> the default value is NULL. If an ENUM is declared NOT NULL, the default
Russ> value is the first element of the list of allowed values.
Russ> I want to make the empty string ('') the default value.
Russ> Yes, I could add it to the list of valid values, but I want the empty string
Russ> to have index=0.
Russ> I am running servers 3.22.20a and 3.22.25. One is under my control and the
Russ> other is under my advisability. It looks like this is not a
Russ> version-specific issue, however.
Russ> Any ideas?
Sorry; The only way to fix this is to extend the MySQL syntax with
create table t1 (a enum ('a','b','c') default ERROR);
(One can't use '' in the above syntax as '' may be a allowed value)
PS: Sorry for the late reply; I am still trying to catch up with the
mails that piled up during my vacation.