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

_____

From: Nagib Abi Fadel [mailto:nagib(dot)abi-fadel(at)usj(dot)edu(dot)lb]
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.