Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Is LONG the only datatype for >2000 characters

Is LONG the only datatype for >2000 characters

From: Zasha Weinberg <zasha_at_tnicholson.com>
Date: 1997/04/05
Message-ID: <01bc4178$e0499190$9208f9ce@ouch>#1/1 








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.



Thanks,



-Z.
Received on Sat Apr 05 1997 - 00:00:00 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US