Re: varchar2 and varchar

From: <e.schrauth_at_smmj.com>
Date: Wed, 14 Oct 1998 09:31:00 -0500
Message-ID: <702cih$298$1_at_smmj.com>


This is from the Oracle manuals

VARCHAR Datatype
The VARCHAR datatype is currently synonymous with the VARCHAR2 datatype. It is recommended that you use VARCHAR2 rather than VARCHAR. In a future version of Oracle7, VARCHAR might be a separate datatype used for variable length character strings compared with different comparison semantics.

Ken Ho Kwok Fai wrote in message <701p9j$r8v_at_eng-ser1.erg.cuhk.edu.hk>...
>In Oracle, there are two datatypes "varchar" and "varchar2". Could anyone
>tell me what is the difference between them? Thank you.
>
>--
>Ken Ho Kwok Fai
Received on Wed Oct 14 1998 - 16:31:00 CEST

Original text of this message