Re: Weird Query

From: VC <boston103_at_hotmail.com>
Date: Mon, 1 Aug 2005 17:49:03 -0400
Message-ID: <UeidnWGgWop_AnPfRVn-sg@comcast.com>

Hi,

"Andreas Mosmann" <keineemails_at_gmx.de> wrote in message news:1122912747.61_at_user.newsoffice.de...
> Turkbear schrieb am 01.08.2005 in
> <vlese1hl24777o6jalga0j7tvlrg787n8j_at_4ax.com>:
>
> I read all above, but only for being sure:
>
> There is no way to tell an oracle database that there is a known
> zero-value string? This information depraves to NULL?

Yep, Oracle cannot tell the difference between a NULL and an empty string which means that Oracle does not conform to the SQL-92 (and above) standard in this respect. SQL Server, by the way, does distinguish NULL from an empty string.

>
> wondering
>
> Andreas
>
> --
> wenn email, dann AndreasMosmann <bei> web <punkt> de
Received on Mon Aug 01 2005 - 16:49:03 CDT