Re: Does Null == ""?

[Randy Chrismon]

> Null is a special value and cannot be tested in the same manner as a
> > string
> or other value.  Yes, there is a difference.  If the column is Null, a
> comparison operation such as a.field == ""  or a.field ==
"something" > will
> both return Null.

> Maybe this document will help:

> A.5.3 Problems with NULL Values
--SNIP lots of good info--

Thanks for the info. Actually, I hadn't gotten as far as thinking
about testing. I am at the point of designing some tables to receive
an exort from a Lotus Notes database. At some point, the MySQL
documentation says that a table with no nullable columns is
better/faster than one with. The Lotus Notes database I'm migrating,
however, has many fields with no values. I infer from the MySQL
documentation that I'm better off doing:

create table my_table(a_field varchar(16) NOT NULL default "", ...)

and exporting my values from Notes as "" rather than using NULL. 

Thanks. 

Randy