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: Jaap W. van Dijk <j.w.vandijk.removethis_at_hetnet.nl>
Date: Mon, 11 Apr 2005 18:37:54 +0200
Message-ID: <3q9l51db0sn41eairpsqdgib55f9t0gqrj@4ax.com> 





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












Original text of this message













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