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

2003-12-11 Thread Dave Page
  From: Nagib Abi Fadel [mailto:[EMAIL PROTECTED] Sent: 11 December 2003 14:37To: generalpost; developPostSubject: [HACKERS] Should we consider empty fields as NULL values when dealing with string columns ? HI, let's say we have the following table :   # C

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

2003-12-11 Thread Nagib Abi Fadel
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.   The issue is that since the column col1 is defined as character with not null attribute, shouldn't we de