Ann W. Harrison wrote:

>At 12:01 PM 10/19/2004, robert-wagner@... wrote:
>
>
>
>
>>why is it bad to use varchar for character strings less than four
>>characters? Only because of the 2 extra bytes holding the string length
>>
>>
>
>Yes, that plus the effect it will have on data compression. The
>length, being binary won't compress with the string and since the
>string is too short to compress the whole lump will sit in the
>record, uncompressed.
>
>
>Regards,
>
>
>

What is the effect of being uncompressed (besides taking up more space)?

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus