[doc] Maximum size for VarChar

[Ruslan Zasukhin]

on 8/8/03 14:43, Erik Mueller-Harder at lists at praxisworks.com wrote:

> Thank you for your previous answers, Ruslan!   Here's one more for you:
> 
> The docs say (and I think I helped write this a couple of years ago!), that
> the max length for VarChar fields is 65,535 bytes (Kernel, page 22).
> 
> Would I be right in saying that the real maximum is 65,528 -- and that that's
> what we should set maxLength to?
> 
> I'm figuring it this way:  to achieve a maximum length of approx. 64K, you'd
> need a page size of 128K (131072 bytes).  Subtract 8 bytes for the page header
> to get 131064 bytes.  Divide by two strings per page (65532) and subtract 4
> bytes overhead per string:  65528.
> 
> Is that correct?

Probably yes, Erik!


> I have a field that nearly always will have about 150 bytes in it, but
> sometimes may have as much as 64K; I'm assuming a large VarChar field is the
> best way to store it?

I also think so, 
Just important to see that atomic page now will 128KB in RAM.


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------