Subject Re: seems bug : Field accepts NULL Values (empty string) even if it is defined with not null constraints ??
Author Svein Erling
--- In firebird-support@yahoogroups.com, Jonathan Neve wrote:
> Martijn Tonies wrote:
>
> >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...

I strongly disagree, NULL simply means "unknown". I know that my
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