V4WS: Any disadvantages to using VarChar instead of String for ~100 byte strings?

[Ruslan Zasukhin]

On 5/23/07 9:01 AM, "Steven Ronald" <stevenrt39 at yahoo.com.au> wrote:

Hi Steven,

> Ruslan,
> 
> I have two fields in a table that typically store
> strings around 100 bytes in length. I could make them
> String 100, but would it save disk space if I use
> VarChar instead? 

Of course

Usually for > 20 length VarChar start win

> Specifically, if I store a string of
> length 30 bytes in a VarChar field, does it only use
> 30 bytes on disk?

30 + 8
 
> Does using VarChar make the table any more susceptible
> to corruption than String?

In general yes, because VarChar is more complex type of storage

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]