Re: top 10 oracle quirks

From: Ben Hutchings <do-not-spam-benh_at_bwsint.com>
Date: 7 Aug 2003 14:58:12 GMT
Message-ID: <slrnbj4q8u.s8.do-not-spam-benh@tin.bwsint.com>

In article <bgtmdb$4n1$1_at_news.mch.sbs.de>, Thomas Gern wrote: <snip>
> 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

It isn't, because VARCHAR2 isn't a type name specified by ANSI.

> because an empty string ('') is different to NULL.

But Oracle still doesn't distinguish between them... does it? Received on Thu Aug 07 2003 - 09:58:12 CDT