Re: varchar vs varchar2

From: Tanel Poder <tanel_at_@peldik.com>
Date: Tue, 5 Aug 2003 03:22:32 +0300
Message-ID: <3f2ef8c9$1_1@news.estpak.ee>

Hi!

Just to add a bit: In 9.2 the "varchar" is converted to "varchar2" automatically when creating a table. But it'd still be wiser to use varchar2 when defining tables/types, since it's the supported and documented datatype.

Tanel.

"Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F2EE567.E09E3AA5_at_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 - 19:22:32 CDT