List:General Discussion« Previous MessageNext Message »
From:Bob Hall Date:September 17 2003 12:31am
Subject:Re: Does Null == ""?
View as plain text  
On Tue, Sep 16, 2003 at 05:39:35PM -0400, Bruce Feist wrote:
> 1)  It is the responsibility of the DBD to document the meaning of NULL if 
> NULLs are allowed.

No, it's not. The meaning of NULL is documented in the SQL specification. 
It's the responsibility of people working with databases to know what that 
definition is.

If you need to specify one of the meanings of NULL, then you should 
use something other than NULL. Since NULL has two meanings, redefining 
it to have only one will create unnecessary confusion. Anyone working on 
or with the database will rightly assume that it has the standard meaning 
defined in the the SQL standard. Any problems caused by the confusion are 
the fault of the person who altered the meaning. If you want to indicate 
something other than the two standard meanings, then you should use 
something other than NULL. Otherwise, you create unnecessary confusion.

Bob Hall
Thread
Does NULL == ""?Randy Chrismon15 Sep
  • Re: Does NULL == ""?Bruce Feist15 Sep
  • RE: Does NULL == ""?Mark Richards15 Sep
  • Re: Does NULL == ""?Brent Baisley15 Sep
    • Re: Does NULL == ""?Keith C. Ivey15 Sep
  • Re: Does NULL == ""?Paul DuBois15 Sep
Re: Does NULL == ""?Alec.Cawley15 Sep
  • RE: Does NULL == ""?Mark Richards15 Sep
Re: Does Null == ""?Randy Chrismon15 Sep
  • RE: Does Null == ""?Mark Richards15 Sep
  • Re: Does Null == ""?Bob Hall16 Sep
    • Re: Does Null == ""?Bruce Feist16 Sep
      • Re: Does Null == ""?Dan Nelson16 Sep
        • Re: Does Null == ""?Bruce Feist16 Sep
          • Re: Does Null == ""?Bob Hall16 Sep
        • Re: Does Null == ""?Bob Hall16 Sep
      • RE: Does Null == ""?Jon Frisby16 Sep
        • Re: Does Null == ""?Bruce Feist16 Sep
          • RE: Does Null == ""?Jon Frisby16 Sep
            • Re: Does Null == ""?Bruce Feist16 Sep
              • RE: Does Null == ""?Jon Frisby16 Sep
              • Re: Does Null == ""?Bob Hall17 Sep
        • Re: Does Null == ""?Bob Hall16 Sep
      • Re: Does Null == ""?Bob Hall16 Sep
    • Re: Does Null == ""?Bob Hall17 Sep
      • Re: Does Null == ""?Bruce Feist18 Sep
        • Re: Does Null == ""?Bob Hall18 Sep
  • Re: Does Null == ""?Haydies18 Sep
    • Re: Does Null == ""?Bob Hall18 Sep