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