Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Does a varchar2 really use a variable amount of space?
In article <35c9d859.24540587_at_news.brookes.ac.uk>,
p0070621_at_brookes.ac.uk (Tommy Wareing) wrote:
> 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.
>
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
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Aug 07 1998 - 08:20:20 CDT
![]() |
![]() |