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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: LONG or VARCHAR2(2000)

Re: LONG or VARCHAR2(2000)

From: William Beilstein <BeilstWH_at_obg.com>
Date: Wed, 10 May 2000 08:45:58 -0400
Message-Id: <10493.105324@fatcity.com>


The following restrictions apply to the LONG data type.

  1. A table can't have more then 1 long COLUMN.
  2. LONG's can't be used in constraints except for the NOT NULL.
  3. You can't create an index on a long column.
  4. You can't pass a LONG value as a procedure argument.
  5. A stored function can't return a Long Value.

Longs, CLOB's and BLOBS are there to store objects and massive amounts of = text or binary. Varchar2 are preferred except if the thing you want to = store is more then 2k in size.
>>> Eric Fang <eric_fang_at_yahoo.com> 05/09/00 11:54PM >>>
we decide to use a field to store the URL in the database, it could be very long but most of them less that 2k characters. But some developers prefer to use VARCHAR2(2000). What's the advantage of using LONG v.s VARCHAR2(2000) or VARCHAR@(2000) v.s LONG?

Any opinion?
Thanks.

Eric Fang



Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/=20
--=20
Author: Eric Fang
  INET: eric_fang_at_yahoo.com=20
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed May 10 2000 - 07:45:58 CDT

Original text of this message

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