RE: Question: How do I do ???
Posted in 1996
CRAIG@CHEMISTRY.CHEM.UTAH.EDU — — source: Informix-list mailing list archive (1991-1998)
Max, I'm not quite sure what you're asking for here. There is no reason you would receive an error since '' is a perfectly valid, non-null string. Where you would get an error is if you tried to set the column=NULL. Don't confuse a database NULL with an empty string. A database NULL is a flag meaning 'no value supplied.' An empty string means a value was supplied, but the value was an empty string. Also, if you're a "C" programmer don't confuse a database NULL with a NULL (ascii 0) in "C". --Craig (craig@chemistry.utah.edu) >The problem is: >I use informix under HPUX. >I've created some tables with a char not null columns >If I insert a '' string in the not null colum I do not receive any >message.