Re: Weird advice : keep varchar2 under 255 bytes ???

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 12 Apr 2005 09:26:40 -0700
Message-ID: <1113322974.638445@yasure>

Le JeanMimi wrote:

> First, thank you all for your help.
>
>

>>From the top of my head: for a column with a maximum length longer
>>than 255 Oracle will use 2 length bytes, otherwise only one. So there
>>is a difference, albeit little.
>>
>>Jaap.

>
>
> Another question :
> If we store a string whose length is < 255 bytes in a varchar2 column
> whose length is > 255 bytes, will Oracle use 2 bytes or 1 byte for the
> length heading ?

Reread Tom Kyte's advice. You'll get none better.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Tue Apr 12 2005 - 11:26:40 CDT