VARCHAR2 started with Oracle7 v7.0.x (circa 1992-ish). Prior to that,
Oracle6 had just VARCHAR with the exact same semantics/definition/behavior
as current VARCHAR2.
At the time, the explanation was that the ANSI SQL definition of "VARCHAR"
was slightly different from Oracle's existing implementation, so they
renamed theirs to VARCHAR2 in case in future they ever decided to offer the
ANSI definition as well...
on 12/10/03 2:39 PM, Tanel Poder at tanel.poder.003_at_mail.ee wrote:
>> I remember Oracle saying that char was going away - about 6 years ago.
>> That's when they created varchar and varchar2.
>>
>> Is this a new rumor?
>
> VARCHAR3 type coming?
>
> Tanel.
>
>
>>
>> Tom Mercadante
>> Oracle Certified Professional
>>
>>
>> -----Original Message-----
>> Sent: Wednesday, December 10, 2003 11:09 AM
>> To: Multiple recipients of list ORACLE-L
>>
>>
>> Hi all:
>>
>> Someone told me that Oracle is planning to retire char
>> variable and therefore they need to be replaced by
>> varchar2. Has anyone heard anything about it?
>>
>> thanks
>>
>> Gene
>>
>> __________________________________
>> Do you Yahoo!?
>> Free Pop-Up Blocker - Get it now
>> http://companion.yahoo.com/
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Gene Gurevich
>> INET: gurelei_at_yahoo.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).
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Mercadante, Thomas F
>> INET: thomas.mercadante_at_labor.state.ny.us
>>
>> 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).
>>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Tim Gorman
INET: tim_at_sagelogix.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 Wed Dec 10 2003 - 21:59:28 CST
