Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Re[2]: char is going away?
-----Original Message-----
From: DENNIS WILLIAMS [mailto:DWILLIAMS@LIFETOUCH.COM]
Sent: Wednesday, December 10, 2003 2:39 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re[2]: char is going away?
Raj, Jonathan
1. I have heard rumors that in other databases the VARCHAR performance isn't
good. In fact, some people that are converting from other databases to
Oracle are pleasantly surprised that Oracle handles VARCHAR well.
2. I have been curious about Oracle's statement that you should use
VARCHAR2. If I was a suspicious person I would say that sounded like a
vendor's attempt to encourage proprietary coding, but I'm not suspicious, no
way.
My point isn't that VARCHAR isn't there, of course it is, but if you were
developing an application to sell and support on several different
databases, you might consider CHAR as a safer bet.Dennis Williams
DBA
Lifetouch, Inc.
dwilliams@lifetouch.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra INET: Rajendra.Jamadagni_at_espn.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Fri Dec 12 2003 - 08:59:25 CST