Re: Any idea for field w/ greater than 255 bytes?
From: darryl snedeker <darryl.snedeker_at_amd.com>
Date: 1995/07/31
Message-ID: <DCLFFK.Dxx_at_txnews.amd.com>#1/1
Date: 1995/07/31
Message-ID: <DCLFFK.Dxx_at_txnews.amd.com>#1/1
If possible, avoid the use of LONG data types. A simple varchar2 can allow for 2000 characters and still permit sub-string searches and manipulation. LONG datatypes can also be inflexible (SQLLOAD). If you absolutely need more than 2000 bytes, LONG is your man and the prior suggestion for SET LONG 20000; is completely correct.
Good Luck
-D Received on Mon Jul 31 1995 - 00:00:00 CEST