RE: LONG or VARCHAR2(2000)

From: <CHUCK_HAMILTON_at_qvc.com>
Date: Thu, 11 May 2000 09:11:37 -0400
Message-Id: <10494.105372@fatcity.com>

Currently varchar and varchar2 are the same in oracle. I'd use a varchar2 for the url if it all possible. Long's don't allow any string operations such as comparisons (i.e. WHERE URL = '...'), functions, etc. Any manipulation or useage of a long must be handled outside of SQL.
--

Chuck Hamilton
QVC Inc.
Enterprise Technical Services
Oracle DBA

                                                                                                                   
                    awaisb_at_paktel                                                                                  
                    .com                 To:     Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>       
                    Ext: NA              cc:     (bcc: CHUCK HAMILTON/QVC)                                         
                    Sent by:             Subject:     RE: LONG or VARCHAR2(2000)                                   
                    root_at_fatcity.                                                                                  
                    com                                                                                            
                                                                                                                   
                                                                                                                   
                    05/11/00                                                                                       
                    02:25 AM                                                                                       
                    Please                                                                                         
                    respond to                                                                                     
                    ORACLE-L

VARCHAR2 is new datatype and didnot allocate rest of the bytes other then enterd data. It is much batter then others.

-----Original Message-----

Sent: Wednesday, May 10, 2000 8:54 AM
To: Multiple recipients of list ORACLE-L

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/
--

Author: Eric Fang
INET: eric_fang_at_yahoo.com

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).
--

Author:
INET: awaisb_at_paktel.com

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