Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Weird advice : keep varchar2 under 255 bytes ???

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

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Mon, 11 Apr 2005 08:21:09 -0700
Message-ID: <1113232647.367129@yasure>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US