Ye, NULL = "Undefined" in every database I've ever used. Null and "" are not equal, NULL and NULL are not equal eigther. Infact absolutly nothing is ever equal to NULL.
Haydies. Database/PHP Developer ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "Martin Gainty" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, September 15, 2003 5:02 PM Subject: Re: NULL : At 11:12 AM -0400 9/15/03, Martin Gainty wrote: : >Randy- : > : >NULL means No Data : >So in the case of a MySQL Column defined as Type String : >NULL is equivalent to "" : : Actually, it's not. : : "" isn't No Data, it's Data with a length of zero. : : -- : Paul DuBois, Senior Technical Writer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
