Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Does a varchar2 really use a variable amount of space?

Re: Does a varchar2 really use a variable amount of space?

From: Tommy Wareing <p0070621_at_brookes.ac.uk>
Date: Thu, 06 Aug 1998 16:23:53 GMT
Message-ID: <35c9d859.24540587@news.brookes.ac.uk>


On Thu, 06 Aug 1998 13:37:33 GMT, nasof_at_hotmail.com wrote:
>Actually it will user 6 bytes: 5 for data and 1 for the length

Which would limit it to 256 characters. Since the maximum is 2000/4000 characters (v.7 / 8 respectively), it must be (?) two bytes.

--
Tommy Wareing
MIS Group
Learning Resources
Oxford Brookes University
01865 483389 Received on Thu Aug 06 1998 - 11:23:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US