pg.ddx.ioUniversity INGRES on Usenet (1985-1995): threads about Berkeley INGRES, QUEL and EQUEL from comp.databases.ingres, comp.databases and net.database
From: Chris McDonald <Chris@macomp.demon.co.uk>
Subject: Re: VARCHAR, WHY THE 2000 Character Limit ??
Date: 1995/11/26
Message-ID: <252943200wnr@macomp.demon.co.uk> (raw)
References: <49794h$pof@carbon.cudenver.edu>
In article: <49794h$pof@carbon.cudenver.edu> ghharrac@ouray.cudenver.edu (George/Jorge)
writes:
>
> Has anyone wondered why varchar/varchar2 has this magical limit of 2000
> characters? Well I have, this limit seems to exist in two databases that
> I have used, namely ORACLE and INGRES. I have looked around for documentation
> to determine if this is a SQL standard but I haven't found anything.
>
> If you can help with this question please send me email, and post the answer.
> Often, its been my experience that developers want more than 2000 characters
> and the oly way to implement this is with raw data types where supported,
> of by busting their data up into 2000 character records and adding a
> sequence number for reassembly.
>
> Answers, thoughts anyone ?
>
> ghharrac@neodata.com
> ghharrac@ouray.cudenver.edu
>
>
>
>
>
>
My understanding of this is that INGRES (as perhaps other RDBMS) uses 2K pages at the
physical end. A tuple in INGRES cannot extend beyond a single page in length. So
irrespective of whether you have a single 2000 character varchar or x columns with a total
tuple width of 2K, you cannot bust this limit.
You have already identified the solution in your question.
--
Chris McDonald