Hello Tom,
On Tuesday, October 10, 2000 à 11:34:49 PM, you said :
TL> "chris markiewicz" <cmarkiew@commnav.com> writes:
>> is there a limit on the upper limit of a VARCHAR? i cannot find one in the
>> documentation.
TL> The physical limit is circa 1Gb under TOAST. There's a purely arbitrary
TL> limit at 10Mb, which I put in on the theory that "varchar(100000000)"
TL> is probably a typo and certainly pretty silly. (If anyone wants to
TL> argue that decision, feel free --- I just did it on the spur of the
TL> moment while changing the old code that checked for declared size <
TL> BLCKSZ.)
Excuse me, what is the 8kb-per-record size limit if we can have so
big fields ?
--
Jean-Christophe Boggio
cat@thefreecat.org
Independant Consultant and Developer
Delphi, Linux, Oracle, Perl