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

Of course, I know this is the best advice (from the best advisor btw =).

I just wanted to discover why this developer was mentioning '255'. I think that this length byte was the (wrong) reason.

DA Morgan <damorgan_at_x.washington.edu> wrote in message news:<1113322974.638445_at_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.
Received on Wed Apr 13 2005 - 05:48:10 CDT