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: BLOB versus VARCHAR

Re: BLOB versus VARCHAR

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 22 May 2006 07:10:56 -0700
Message-ID: <1148307056.172551.176100@j73g2000cwa.googlegroups.com> 





If you are definite that the size of data in these columns will
never exceed 2000 chars then use VARCHAR2, else use
CLOB with ENABLE STORAGE IN ROW (note: Clob, not Blob,
the latter is for storing binary data while the former is for
character data.)



Hth,

     Vladimir M. Zakharychev
     N-Networks, makers of Dynamic PSP(tm)
     http://www.dynamicpsp.com


Received on Mon May 22 2006 - 09:10:56 CDT












Original text of this message













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