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

From: <nasof_at_hotmail.com>
Date: Fri, 07 Aug 1998 13:20:20 GMT
Message-ID: <6qeuul$qa7$1@nnrp1.dejanews.com>

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