Re: [HACKERS] Should we consider empty fields as NULL values when dealing with string columns ?

[Dave Page]

From: Nagib Abi Fadel [mailto:[EMAIL PROTECTED] Sent: 11 December 2003 14:37 To: generalpost; developPost Subject: [HACKERS] Should we consider empty fields as NULL values when dealing with string columns ? HI, let's say we have the following table :   # CREATE TABLE tempo (col1 varchar(3) not null); CREATE TABLE # insert INTO tempo VALUES (''); INSERT 11420541 1   the insert command works.     As it should. NULL != ''. In other words, NULL is no value at all, whilst '' is an empty string which is a value, albeit one of zero length.   Regards, Dave.