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

From: <oliver.willandsen_at_sg.cec.be>
Date: Wed, 05 Aug 1998 12:59:05 GMT
Message-ID: <6q9kup$l66$1@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

--
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 - 07:59:05 CDT

This message: [ Message body ]
Next message: Kenneth He: "yrdy"
Previous message: John Finn: "Delete without rollback ? It it possible ?"
In reply to: Hans Tallis: "Does a varchar2 really use a variable amount of space?"
Next in thread: Jason Hooper: "Re: Does a varchar2 really use a variable amount of space?"
Reply: Jason Hooper: "Re: Does a varchar2 really use a variable amount of space?"
Reply: nasof_at_hotmail.com: "Re: Does a varchar2 really use a variable amount of space?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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