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 -> Weird advice : keep varchar2 under 255 bytes ???

Weird advice : keep varchar2 under 255 bytes ???

From: Le JeanMimi <scjm_at_noos.fr>
Date: 11 Apr 2005 05:44:14 -0700
Message-ID: <c7be5048.0504110444.52f8a489@posting.google.com> 





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
Received on Mon Apr 11 2005 - 07:44:14 CDT












Original text of this message













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