| Subject | Re: [firebird-support] Re: seems bug : Field accepts NULL Values (empty string) even if it is defined w |
|---|---|
| Author | Martijn Tonies |
| Post date | 2004-03-16T10:54:24Z |
> > >You're answering your own question: '' (empty string) is NOT NULL.It wouldn't be the first ;-)
> > >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? ;)
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com