Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Weird advice : keep varchar2 under 255 bytes ???
On 11 Apr 2005 08:57:23 -0700, fitzjarrell_at_cox.net wrote:
...
> Declaring a column as VARCHAR2(255) and one as
>VARCHAR2(4000) and populating both with the same data requires Oracle
>to allocate the same space for both; the VARCHAR2(4000) is not longer,
>nor does it require more space in this situation.
...
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. Received on Mon Apr 11 2005 - 11:37:54 CDT