Re: Is LONG the only datatype for >2000 characters

From: Michael Ho <infoage_at_hk.super.net>
Date: 1997/04/09
Message-ID: <334A8E59.2D0E@hk.super.net>#1/1

Zasha Weinberg wrote:
>
> If VARCHAR2 could handle more than 2000 characters, I have a table in which
> I would use several of these. This is apparently not possible with LONG.
> Also LONG has a number of serious restrictions (you can do very little with
> it - I'd like to use RTRIM with it, for example).
>
> If I need to have text fields with potentially more than 2000 characters in
> them, do I have any options other than LONG.

I don't think you want separating 1 column varchar2(6000) into 3 column of
varchar2(2000). So use long, it is for that purpose.

Also, interest to know why is there such a requirement ? You mean user input
more than 2000 character into one field ? Received on Wed Apr 09 1997 - 00:00:00 CDT