Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> NULL and zero length strings ?

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@stargate1.inet.it>

Hi all !

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..

Any idea on how to solve this problem...

Any session option to set ?

TIA



Paolo Bormida
Torino - Italy
Received on Mon Jul 19 1999 - 11:49:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US