Subject | Re: seems bug : Field accepts NULL Values (empty string) even if it is defined w |
---|---|
Author | Alexander V.Nevsky |
Post date | 2004-03-16T10:46:30Z |
--- In firebird-support@yahoogroups.com, Jonathan Neve <jonathan@m...>
wrote:
Best regards,
Alexander.
wrote:
> Martijn Tonies wrote:In SQL standard? ;)
>
> >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...
Best regards,
Alexander.