From: Nagib Abi Fadel [mailto:nagib.abi-fadel@usj.edu.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.