Re: So what's null then if it's not nothing?

From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Mon, 21 Nov 2005 13:58:48 -0800
Message-ID: <hl14o1h8tnom6jn695js7seeu02i2veg75@4ax.com>

On Fri, 18 Nov 2005 22:42:45 +0100, Hugo Kornelis <hugo_at_pe_NO_rFact.in_SPAM_fo> wrote:

>On 17 Nov 2005 18:20:50 -0800, michael_at_preece.net wrote:
>
>>Rats! I just read that the ANSI standard says NULL is char(0)!

I have read that the moon is made of green cheese.

I did not accept the statement.

[snip]

>Of course, ANSI has written lots of standards. The ASCII character set
>might well be one of them - and in ASCII, char(0) is indeed defined as
>NUL (null). The only thing that this null shares with SQL's null is the
>name.

No, it does not. It has the same pronunciation, but it is a different spelling.

[snip]

Sincerely,

Gene Wirchenko Received on Mon Nov 21 2005 - 15:58:48 CST