| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> comp.databases.theory -> Re: So what's null then if it's not nothing?
Rats! I just read that the ANSI standard says NULL is char(0)! That's
probably why some Pick/MV implementations use char(0) as an
end-of-record marker - becuase that fits more with what the ANSI
standard goes on to say about NULL-terminated fields. So SQL is wrong
(confuses NULL (nothing) with UNKNOWN (maybe NULL, maybe something
else)) and ANSI is wrong too (char(0) is not nothing)! Phew - thank God
for Pick!
Mike. Received on Thu Nov 17 2005 - 20:20:50 CST
 |
 |