Subject | Re: seems bug : Field accepts NULL Values (empty string) even if it is defined w |
---|---|
Author | peter_jacobi.rm |
Post date | 2004-03-16T11:48:35Z |
--- In firebird-support@yahoogroups.com, wrote:
What about a column "academic title"? May hold 'PhD' or '' and unknown
is not ''.
But I agree there are a many cases where this distinction is weak.
For my designs I try to use a specific value for null-ness. If domain
analysis confirms, that '' has no distinct meaning from NULL, I
declare the column NOT NULL DEFAULT ''.
For the often used used sex field, I use CHAR(1) NOT NULL DEFAULT '9'
thanks to the wise guys at ISO.
Regards,
Peter Jacobi
> null. However, '' can hardly be considered a value. What's thenothing
> difference between not putting anything in a column, and putting
What about a column "academic title"? May hold 'PhD' or '' and unknown
is not ''.
But I agree there are a many cases where this distinction is weak.
For my designs I try to use a specific value for null-ness. If domain
analysis confirms, that '' has no distinct meaning from NULL, I
declare the column NOT NULL DEFAULT ''.
For the often used used sex field, I use CHAR(1) NOT NULL DEFAULT '9'
thanks to the wise guys at ISO.
Regards,
Peter Jacobi