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
