Subject Re: [firebird-support] Re: seems bug : Field accepts NULL Values (empty string) even if it is defined w
Author Martijn Tonies
> > >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...
> In SQL standard? ;)

It wouldn't be the first ;-)

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions