Re: Long Char field

From: Markus Schwabe <mschwabe_at_gscout.de>
Date: 2000/05/26
Message-ID: <8gleg8$q34$1@news4.muc.eurocyber.net>#1/1

You can either define:

CLOB column (I think in Oracle 8.1.5 and above) : A character large object containing single-byte characters. Both fixed-width and variable-width character sets are supported, both using the CHAR database character set. Maximum size is 4 gigabytes.

The built-in LOB datatypes BLOB, CLOB, and NCLOB (stored internally), and the BFILE (stored externally), can store large and unstructured data such as text, image, video, and spatial data up to 4 gigabytes in size.

or:

Try to AVOID the following if you have Oracle 8!!! They have many restrictions!

2) LONG column

Character data of variable length up to 2 gigabytes

3) LONG RAW column

Raw binary data of variable length up to 2 gigabytes

If you have it, look at the docu under
Oracle8i SQL Reference/Basic Elements of Oracle SQL/Datatypes.

HTH
Markus

Jose A. Silva <jsilvae_at_yahoo.com> schrieb in im Newsbeitrag: 8gk1d4$ono9_at_nova.entelchile.net...
> Is it posible to store a very large text in oracle ? let's say 3 pages of
> text.
> Thanks.
>
>
Received on Fri May 26 2000 - 00:00:00 CDT