Re: Oracle NULL vs '' revisited

From: David Portas <REMOVE_BEFORE_REPLYING_dportas_at_acm.org>
Date: Sat, 18 Aug 2007 13:28:41 +0100
Message-ID: <KeadnX2UpN9neFvbnZ2dnUVZ8sCsnZ2d@giganews.com>

"William Robertson" <williamr2019_at_googlemail.com> wrote in message news:1187428777.650700.87100_at_w3g2000hsg.googlegroups.com...

> Because more than one rival product
> is different to Oracle, Oracle gets called "non-standard". Is that the
> basis for "Oracle doesn't adhere to SQL standards for the distinction"
> or am I missing something?
>

The basis for saying that "Oracle doesn't adhere to SQL standards" is the ANSI/ISO/IEC SQL standard document.
ISO/IEC 9075-2:2003. Section 4.2.1:

"A character string is a sequence of characters. All the characters in a character string are taken from a single character set. A character string has a length, which is the number of characters in the sequence. The length is 0 (zero) or a positive integer."

-- 
David Portas

Received on Sat Aug 18 2007 - 07:28:41 CDT