Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Weird advice : keep varchar2 under 255 bytes ???
Le JeanMimi wrote:
> Hello,
>
> A developer told us that it was best to avoid declaring VARCHAR2
> columns of more than 255 bytes when possible.
> He pretends that Oracle will reserve huge blocks for the resultset
> when the varchar2 size is over 255.
>
> I've never heard of that before. (and don't really believe it)
> May be in a previous version ?
>
> Can you help me ?
>
> Thanks in advance
>
> JM
Find a new developer or send this one for some training.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Mon Apr 11 2005 - 10:21:09 CDT
![]() |
![]() |