_____  

	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.
 
Regards, Dave.







 



From: Nagib Abi Fadel 
  [mailto:nagib.abi-fadel@usj.edu.lb] 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 :
 
# 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.
Thu, 11 Dec 2003 14:52:43 -0000
"Dave Page" <dpage@vale-housing.co.uk>
Re: [HACKERS] Should we consider empty fields as NULL values when
	dealing with string columns ?