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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Shell I use CLOB column?

Re: Shell I use CLOB column?

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 20 Dec 2004 14:06:39 -0800
Message-ID: <113580399.0000e6f5.008@drn.newsguy.com>


In article <1103575762.507809.231610_at_f14g2000cwb.googlegroups.com>, kenosha says...
>
>
>I need to store character data of size up to 64K.
>Is it a good case for using CLOB column? - I was thinking
>that CLOB was designed for much larger sized data, but on
>the other hand, there doesn't seem to be good alternative -
>VARCHAR is not large enough and breaking it up into several
>records to use VARCHAR looks ugly.
>
>Please advise.
>

clobs were designed for all text over 4000 bytes.... it would be the appropriate type to store 64k of text.

-- 
Thomas Kyte
Oracle Public Sector
http://asktom.oracle.com/
opinions are my own and may not reflect those of Oracle Corporation
Received on Mon Dec 20 2004 - 16:06:39 CST

Original text of this message

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