RE: [PEAR-DEV] quote and NULL

i agree, especially in the context of a SELECT statement. "SELECT FROM table WHERE col=NULL" or "SELECT FROM table WHERE col=''" will probably not do what you expect it to, whereas "SELECT FROM table WHERE col IS NULL" will probably do what you'd expect. > -----Original Message----- > From: Chuck Hagenbuch [mailto:chuck@horde.org] > Subject: Re: [PEAR-DEV] quote and NULL > > Quoting "Tomas V.V.Cox" <cox@idecnet.com>: > > > Is there any problem if DB::quote by default return the NULL string > > also when the value is '' (now it returns NULL only when $var === > > null) ? > > '' and NULL are _very_ different things in SQL. Please don't do this. > > -chuck