From daemon Wed Feb 7 07:28:50 1996 Received: from ccvm.sunysb.edu by alice.jcc.com; (5.65v3.0/1.1.8.2/01Aug94-0142PM) id AA16737; Wed, 7 Feb 1996 07:28:48 -0500 Message-Id: <9602071228.AA16737@alice.jcc.com> Received: from CCVM.SUNYSB.EDU by ccvm.sunysb.edu (IBM VM SMTP V2R3) with BSMTP id 2975; Wed, 07 Feb 96 07:17:19 EST Received: from CCVM.SUNYSB.EDU (NJE origin LISTSERV@SBCCVM) by CCVM.SUNYSB.EDU (LMail V1.2a/1.8a) with BSMTP id 8067; Wed, 7 Feb 1996 07:17:17 -0500 Date: Wed, 7 Feb 1996 07:03:00 PST Reply-To: "ORACLE database mailing list." Sender: "ORACLE database mailing list." From: "Allison, Paul" Subject: Re: VARCHAR2(2000) X-To: ORACLE-L postings To: Multiple recipients of list ORACLE-L Don't know, that is a question for Oracle. I got this from the Admin guide section on estimated table sizing. Paul T. Allison pallison@ppg.com ---------- From: owner-oracle-l%CCVM.SUNYSB.EDU To: Multiple recipients of list ORACLE-L Subject: Re: VARCHAR2(2000) Date: Tuesday, February 06, 1996 10:45AM > > Actually, every field with length greater than 250 takes > 2 extra space bytes. This could be significant in a large table. > > Paul T. Allison > pallison@ppg.com Why 250, not 255. One can certainly store '2000' in two bytes. What's the purpose of the third?... To store whether the column lenght is stored in one or two bytes ? Ian MacGregor Stanford Linear Accelerator Center ian@slac.stanford.edu