Re: Any idea for field w/ greater than 255 bytes?

chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:

>thorn_at_w3eax.umd.edu (Greg KD3SU) wrote:
 

>>I am trying to have one column for a comment (string) in a table
>>that is greater than 255. I tried to use LONG but it does
>>not work. The book says a LONG can hold up to 2 gigabytes of
>>info. Anyone have any ideas? The error I get says :

If you are using Oracle 7, a varchar2 field can be up to 2000 characters long.

>>Field in data file exceeded maximum specified length
 

>>Is there another datatype that I might be able use that I'm not
>>aware of?
 

>There's a system variable that limits the display length of a LONG in
>SQLPlus called "LONG". Try setting that to a higher value. Ex. SET
>LONG=5000.
 
>HTH
Received on Thu Aug 03 1995 - 00:00:00 CEST