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: Eric Junkermann <eric_at_deptj.demon.co.uk>
Date: Fri, 07 Aug 1998 21:21:45 GMT
Message-ID: <35cb6c7f.9308524@news.demon.co.uk> 





On Fri, 07 Aug 1998 13:20:20 GMT, nasof_at_hotmail.com wrote:



>


>This is a good question, the Oracle8 DBA Handbook says add 1 byte for rows


>under 250 and 2 bytes for columns over 250.  Any one know for sure?


>


>-Frank


>





Oracle 7 is definitely 1 and 3 as I said - since the limit on VARCHAR2
length is larger in O8, I can't see how 2 bytes would work there.



Eric
Received on Fri Aug 07 1998 - 16:21:45 CDT












Original text of this message













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