Re: top 10 oracle quirks

From: Thomas Gern <Thomas.Gern_at_siemens.com>
Date: Thu, 07 Aug 2003 16:06:35 +0200
Message-ID: <bgtmdb$4n1$1@news.mch.sbs.de>

programmer wrote:

>>>>2. VARCHAR2
>>>>
>>>>the 2!

>
>
> the varchar field type is an SQL standard, but subject to change by the
> standards commitee.
>
> so Oracle created varchar2, which is currently the same as varchar, but
> guaranteed never to change.
>
>

AFAIK is VARCHAR != VARCHAR2

Oracles VARCHAR isn't ANSI conforming 'cause Oracle handels an empty string ('') as NULL

The VARCHAR2 data type is therefore ANSI conforming because an empty string ('') is different to NULL.

HTH
Thomas Received on Thu Aug 07 2003 - 09:06:35 CDT