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>
Paolo Bormida
Torino - Italy
Received on Mon Jul 19 1999 - 18:49:32 CEST
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