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: Keith McCammon <keithm@microrim.com>
To: ghharrac@ouray.cudenver.edu
Subject: Re: VARCHAR, WHY THE 2000 Character Limit ??
Date: 1995/11/26
Message-ID: <49a8b8$546@news1.wolfe.net> (raw)
References: <49794h$pof@carbon.cudenver.edu>

ghharrac@ouray.cudenver.edu (George/Jorge) wrote:
>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.


I'm not sure if there is a size limit specified by ANSI 92, but 
I know that R:BASE supports 256MB VARCHARs, so I'm sure the 
ANSI standard is at least that much. Perhaps the Oracle and 
Ingres limitations are related to the maximum row size (?)

Keith McCammon
keithm@microrim.com
http://www.microrim.com
--------------------------------------------------------------







view thread (17+ messages)  latest in thread

Message-ID: <49a8b8$546@news1.wolfe.net>
Permalink:  ../49a8b8$546@news1.wolfe.net/

 · 


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