unexpected NULL values

Posted in 1998

ProzessDV — 4 Nov 1998 17:02:20 GMT — source: Informix-list mailing list archive (1991-1998)

We migrate from an old database (DDB/4) to OWS 7.22 on SCO UNIX. When a row was inserted on the old system into a char-column by a host variable containing nothing ( colx = "") the database did not contain anything, either. But informix inserts a NULL value into this column. Is there a way to leave our code unchanged but to insert "nothing" ("") instead of a NULL value? Thanks in advance, S'kr'