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

From: Jason Hooper <hooperj_at_parks-sa.co.za>
Date: Wed, 5 Aug 1998 10:35:26 +0200
Message-ID: <6qbtnt$ndr$1@news01.iafrica.com>

oliver.willandsen_at_sg.cec.be wrote in message <6q9kup$l66$1_at_nnrp1.dejanews.com>...
>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
>

I think it will actually use 7 (two for the length?)
>--
>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
Received on Wed Aug 05 1998 - 03:35:26 CDT