Null vs. Empty

[Ruslan Zasukhin]

On 11/14/04 2:32 AM, "jda" <jda at his.com> wrote:

>> So standard SQL practice to look for empty or NULL strings is the following:
>> 
>>    SELECT MyTextField
>>    FROM MyTable
>>    WHERE len(MyTextField) = 0 OR MyTextField is NULL
>> 
>> You could just not allow NULLs for the field. Or make sure that
>> every time a record is added that it be set to an empty string by
>> default.
>> 
>> Ruslan, in Valentina 2, can we remove the NULL flag from a Text field?
>> 
> 
> Thanks, Frank.
> 
> Actually, I used NULL instead of an empty string in V1.x (where I
> think you could do that) because that way I saved 128 bytes (the size
> of my segments) per empty text field -- since I have about 34 text
> fields per record, and they are often empty, making them NULL instead
> of an empty string saved a lot of space.
> 
> Is this still the case in V2, Ruslan?

yes

> I mean, will an empty text
> field still take up one segment and a NULL 0?

yes

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------