Any other DBMS behaves the same way. This fooled a lot of our COBOL programmers when we switched from VSAM to DB2 at work.

NULL != empty string != spaces != low values != high values

----- Original Message -----
From: Jonathan Neve
To: firebird-support@yahoogroups.com
Sent: Tuesday, March 16, 2004 2:43 AM
Subject: Re: [firebird-support] seems bug : Field accepts NULL Values (empty string) even if it is defined with not null constraints ??


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...

Jonathan Neve.


------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]