Shell I use CLOB column?
This is a discussion on Shell I use CLOB column? within the Oracle Miscellaneous forums, part of the Oracle Database category; --> I need to store character data of size up to 64K. Is it a good case for using CLOB ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 05:26 AM
| ||||
| ||||
 Shell I use CLOB column? 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.      |
|
04-08-2008, 05:26 AM
| ||||
| ||||
| Re: Shell I use CLOB column? In article <1103575762.507809.231610@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 |
Linear Mode
