Re: varchar vs varchar2

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Mon, 04 Aug 2003 15:59:51 -0700
Message-ID: <3F2EE567.E09E3AA5@exxesolutions.com>

Jack wrote:

> <Quotes from documentation>
> The VARCHAR datatype is synonymous with the VARCHAR2 datatype. To avoid
> possible changes in behavior, always use the VARCHAR2 datatype to store
> variable-length character strings.
>
> </Quotes>
>
> I wonder what "possible changes in behavior" could be?
>
> Thanks.

VARCHAR is a 'C' language structure, not Oracle. It will work right up until it doesn't. Oracle makes no guarantee that it will work and will not support it.

That ... is why it is worth typing the '2'.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Aug 04 2003 - 17:59:51 CDT