List:General Discussion« Previous MessageNext Message »
From:Jon Frisby Date:September 16 2003 9:56pm
Subject:RE: Does Null == ""?
View as plain text  
> I didn't know that.  What *does* it do if you specify a 
> string literal that's smaller than the CHAR(20) field, then?  
> Pad it with binary zeros?

MySQL returns a properly trimmed string, although it will allocate a
fixed amount of space for the storage.  Other databases pad with blank
spaces.


> > One solution I've seen proposed is to allow the programmer to define
> > NULL as an enumeration.  Basically "this value can contain 
> a *value*, or
> > it can contain one of N specific NULL values that I define".
> 
> I assume that this would be done by the database designer 
> rather than the programmer!  It sounds reasonable enough, but 
> possibly overengineering.

A slip of the tongue (fingers) on my part...  The DB designer would be
allowed to define the possible meanings of NULL for a column as part of
the schema.

-JF

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