NULL VarCharString (was Slow NOT searches)
    jda 
    jda at his.com
       
    Wed Dec 28 22:12:27 CST 2005
    
    
  
>Advantage of making a VarChar field nullable is that you would be able to
>distinguish between when a field legitimately contains an empty string,
>either by default or explicit assignment, and when it contains no string at
>all because none has been supplied for it.  You could achieve the same
>result by choosing some arbitrary string of your choice to signify "no
>string supplied", such as "NULL" for example.
>
>Disadvantages are more storage required for storing the per-record isNull
>information, and slower execution because the nullable information needs to
>be taken into consideration for many operations you may perform on the
>field.
>
>That make sense?
>
>--Ed
>
It would, Ed. But I tested this after posting, and searching for 
WHERE varCharField IS NULL got nothing (all fields had been created 
after SetBlank). Whereas searching for WHERE varCharField IS NOT NULL 
returned all. So I'm thinking that Valentina ignores Nullable for 
varCharFields. Is that right, Ruslan?
Jon
    
    
More information about the Valentina-beta
mailing list