Re[2]: TEXT vs VARCHAR

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