pg.ddx.io  University INGRES on Usenet (1985-1995): threads about Berkeley INGRES, QUEL and EQUEL from comp.databases.ingres, comp.databases and net.database  
help / color / mirror / Atom feed
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







view thread (17+ messages)  latest in thread

Message-ID: <252943200wnr@macomp.demon.co.uk>
Permalink:  ../252943200wnr@macomp.demon.co.uk/

 · 


This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox