Do not use null to represent a value of zero, because they are not
equivalent.
(Oracle currently treats a character value with a length of zero as null.
However,
this may not continue to be true in future releases, and Oracle recommends
that
you do not treat empty strings the same as NULLs.)
> -----Original Message-----
> From: GKor_at_rdw.nl [SMTP:GKor_at_rdw.nl]
> Sent: Wednesday, November 15, 2000 8:05 AM
> To: Multiple recipients of list ORACLE-L
> Subject: null values
>
> hi all
>
> when i insert a value '' in a varchar2 field with nulls allowed
> this value is stored as a NULL value, is this correct ?
> the developers are not aware of this behavior and they think
> oracle will
> store a SPACE.
>
>
>
> tia
> g.g. kor
Received on Wed Nov 15 2000 - 08:29:37 CST
