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

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

LONG or VARCHAR2(2000)

From: Eric Fang <eric_fang_at_yahoo.com>
Date: Tue, 9 May 2000 19:46:16 -0700 (PDT)
Message-Id: <10492.105299@fatcity.com>


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/ Received on Tue May 09 2000 - 21:46:16 CDT

Original text of this message

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