Peter Brawley wrote:
Perhaps Oracle also has such a setting too. MySQL doesn't.
As a matter of fact, Oracle goes the other way in that if you store ''
into a VARCHAR field, it actually stores a NULL there. But it's
inconsistent in that doesn't consider a NULL varchar column to be = ''
(a literal
Narasimha,
In programming languages, a 'null string' is empty, but in ANSI SQL,
NULL means unknown, _not_ empty, so
in ANSI SQL, NULLs are never equal to anything, not even themselves: the
expressions NULL=NULL, NULL<>NULL and NULL='' all evaluate to NULL.
Microsoft SQL has an 'ansi_nulls' setti
