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

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 ? Received on Tue Apr 12 2005 - 01:51:43 CDT