VChar vs VText

[jda]

Hi Frank,

>You do not  set the segment size with a VarChar, instead it is the 
>maximum size.

Ah, of course. Should have remembered that...

>  1022 is the minimum value you should use, at least for double byte 
>encodings like UTF-16 which is the default.

Wasn't that for V1? I thought it changed in V2 to something over 5000. Ruslan?

>  I'm not sure what the header size is, so if you need to jump to the 
>next optimal size, I don't think 2044 is the proper value, probably 
>it should be less. Perhaps Ruslan can comment on this?
>
>My understanding is that VarChar is faster and more space efficient 
>than VText. Really, Vtext is only for holding potentially large 
>amounts of text.
>

Sounds like CVhar then. Thanks.

Jon