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

In article <6q9kup$l66$1_at_nnrp1.dejanews.com>,   oliver.willandsen_at_sg.cec.be wrote:
> In article <35C835EB.7B3188FE_at_ers.com>,
> Hans Tallis <tallis_at_ers.com> wrote:
> > If I declare a column varchar2(1000), and put "hello" into a row, is the
> > database still using all 1000 bytes to store the row?
> >
> >
> NO - it'll use 5 bytes
>
> --
> Oliver Willandsen - European Commission
> http://europa.eu.int
> All remarks are my own and do not necessarily
> reflect official European Commission policy
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

Actually it will user 6 bytes: 5 for data and 1 for the length

-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 Thu Aug 06 1998 - 08:37:33 CDT