Subject | Re: seems bug : Field accepts NULL Values (empty string) even if it is defined with not null constraints ?? |
---|---|
Author | Svein Erling |
Post date | 2004-03-16T11:05:57Z |
--- In firebird-support@yahoogroups.com, Jonathan Neve wrote:
wallet is empty (0), and have no idea how much money Bill Gates has
(NULL). That is a huge difference.
By the way, don't worry Martijn - the wallet was just an example and
there'll be Bamsemums at Fulda.
Set
> Martijn Tonies wrote:I strongly disagree, NULL simply means "unknown". I know that my
>
> >You're answering your own question: '' (empty string) is NOT NULL.
> >NULL is NULL (empty). An empty string is a value. NULL is a state,
> >so is "NOT NULL".
> >
> IMHO, this unique feature could nearly be considered a bug...
wallet is empty (0), and have no idea how much money Bill Gates has
(NULL). That is a huge difference.
By the way, don't worry Martijn - the wallet was just an example and
there'll be Bamsemums at Fulda.
Set