MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Haydies Date:September 15 2003 4:21pm
Subject:Re: NULL
View as plain text  
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" <paul@stripped>
To: "Martin Gainty" <mgainty@stripped>; <rchrismon@stripped>
Cc: <mysql@stripped>
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

Thread
NULLMartin Gainty15 Sep
  • Re: NULLPaul DuBois15 Sep
  • Re: NULLHaydies15 Sep
    • Re: NULLPaul DuBois15 Sep