NULL and zero length strings ?

From: Paolo Bormida <bormidap_at_tin.it>
Date: Mon, 19 Jul 1999 18:49:32 +0200
Message-ID: <7mvku2$18m6$1_at_stargate1.inet.it>


[Quoted] Hi all !

[Quoted] I have to admit I am somewhat new to Oracle and just discovered ORACLE 7.3.4 is treating a zero length string (like this '') as NULL.

We have an application sending INSERT statements on a table with not-nullable char/varchar columns; running it against ORACLE we have a few problems..

[Quoted] Any idea on how to solve this problem...

Any session option to set ?

TIA



Paolo Bormida
Torino - Italy
Received on Mon Jul 19 1999 - 18:49:32 CEST

Original text of this message