VChar vs VText

jda jda at his.com
Fri Nov 25 14:43:57 CST 2005


Hi Ruslan,

I'm going to add about 12 new fields to my db (API way). They could 
be VText (which I mostly use) or VChar (I don't care if they are 
limited to 1K or so of text). Is there any *real* advantage of one 
over the other (storage-wise)? I expect these fields will generally 
store from 5-200 characters or so.

If I use VChar, what's the smallest segment size that conserves 
space? I recall something like 5024.

If VText, what's the smallest that makes sense (32)?

Thanks,

Jon


More information about the Valentina mailing list