Re: Regarding NULL and '' (null string) treatment in MYSQL

[Shankar Unni]

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 '', I mean; or even a PL/SQL variable assigned a '' value).