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

On Mon, 21 Nov 2005 13:58:48 -0800, Gene Wirchenko wrote:

>On Fri, 18 Nov 2005 22:42:45 +0100, Hugo Kornelis
><hugo_at_pe_NO_rFact.in_SPAM_fo> wrote:
>
(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.

Hi Gene,

I didn't add the parenthesed "null", it's part of the full description. Just as char(1) is described as SOH (start of heading). Etc.

To me, this reads that char(0) is defined as null, and has NUL as the official abbreviation.

Source: http://www.lookuptables.com/

Best, Hugo

-- 

(Remove _NO_ and _SPAM_ to get my e-mail address)