Re: difference b/w varchar and varchar2

From: Marc Parkinson <marcpark_at_uswest.net>
Date: Wed, 08 Dec 1999 21:18:02 -0700
Message-ID: <384F2D7A.DC3C824A@uswest.net>

Aamir,

The VARCHAR datatype is currently synonymous with the VARCHAR2 datatype. However, in a future version of Oracle, VARCHAR might store variable-length character strings compared with different comparison semantics. Therefore, you should use the VARCHAR2 datatype to store variable-length character strings.

Marc G. Parkinson
marcpark_at_uswest.net

Aamir Khan wrote:

> What is the difference between varchar and varchar2 ???
>
> Regards,
> Aamir Khan
Received on Wed Dec 08 1999 - 22:18:02 CST