List:General Discussion« Previous MessageNext Message »
From:Shankar Unni Date:March 30 2005 6:34pm
Subject: Re: Regarding NULL and '' (null string) treatment in MYSQL
View as plain text  
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).

Thread
Regarding NULL and '' (null string) treatment in MYSQLlakshmi.narasimharao30 Mar
  • Re: Regarding NULL and '' (null string) treatment in MYSQLPeter Brawley30 Mar
    • Re: Regarding NULL and '' (null string) treatment in MYSQLShankar Unni30 Mar