Shell I use CLOB column?

#1

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.

#2

In article <1103575762.507809.231610 (AT) f14g2000cwb (DOT) googlegroups.com>, kenosha
says...

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Shell I use CLOB column?

comp.databases.oracle.misc comp.databases.oracle.misc

Shell I use CLOB column? - 12-20-2004 , 02:49 PM

Re: Shell I use CLOB column? - 12-20-2004 , 04:06 PM