nuacct=> create table users (
nuacct-> recno int,
nuacct-> custid int unique,
nuacct-> username char(14) not null,
nuacct-> service int
nuacct-> );
nuacct=> insert into users values
nuacct-> ( 0, 0, '', 0 );
INSERT 18241 1
??? Shouldn't that have failed, generating an error ???
No, but this will:
nuacct=> insert into users values ( 0, 0, null, 0 );
'' is a zero length string not a null.
Cheers,
Brook