Path: utzoo!utgpu!jarvis.csri.toronto.edu!mailrus!cs.utexas.edu!rutgers!sunybcs!canisius!pavlov
From: pavlov@canisius.UUCP (Greg Pavlov)
Newsgroups: comp.databases
Subject: Re: variable record length
Message-ID: <2655@canisius.UUCP>
Date: 3 Feb 90 21:23:36 GMT
References: <Jan.19.11.33.05.1990.17070@presto.IG.COM> <410@ssc.UUCP> <DSIMSON.90Jan30170332@arthur.oracle.com>
Distribution: usa
Organization: Canisius College, Buffalo N.Y. 14208
Lines: 13

In article <DSIMSON.90Jan30170332@arthur.oracle.com>, dsimson@oracle.com (David Simson) writes:

> ...(talking about a record with a declared 60-byte filed in an Oracle table)
  .....................................  If you insert a record
> into this table where the column has a value of length 30, only 30
> bytes (assuming we're not talking multi-byte character sets) plus an
> overhead of 1 byte for the length is stored.
> 
  Well, the overhead is actually greater than one byte.  Since the resulting
  RECORD is variable in length as well, that has to be delineated as well.


  greg pavlov, fstrf, amherst, ny