VChar vs VText

[Frank Schima]

Hi Jon,


On Nov 25, 2005, at 3:04 PM, jda wrote:

> Is there any advantage to VarChar (remember, typical data of 5-200  
> chars per fields, UTF-16 encoding)? And what segment size is  
> optimal (for saving storage space)?

You do not  set the segment size with a VarChar, instead it is the  
maximum size. 1022 is the minimum value you should use, at least for  
double byte encodings like UTF-16 which is the default. 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.


Best regards,
Frank Schima

I'm currently job hunting:
<http://homepage.mac.com/macsforever2000/resume.html>