From: Chris McDonald Subject: Re: VARCHAR, WHY THE 2000 Character Limit ?? Date: 1995/11/26 Message-ID: <252943200wnr@macomp.demon.co.uk> X-Original-Message-ID: <252943200wnr@macomp.demon.co.uk>#1/1 X-Deja-AN: 120213858 x-nntp-posting-host: macomp.demon.co.uk references: <49794h$pof@carbon.cudenver.edu> x-smtp-posting-host: post.demon.co.uk [Sun, 26 Nov 95 18:08:08 GMT] x-broken-date: Sunday, Nov 26, 1995 15.52.36 organization: Myorganisation reply-to: Chris@macomp.demon.co.uk newsgroups: comp.databases.ingres 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