Re: Bug NULL ???
From: Leo Van Nieuwenhuyse <leo.van.nieuwenhuyse_at_pandora.be>
Date: 2000/07/29
Message-ID: <Tupg5.24303$_a.375337_at_afrodite.telenet-ops.be>#1/1
Date: 2000/07/29
Message-ID: <Tupg5.24303$_a.375337_at_afrodite.telenet-ops.be>#1/1
What do you mean by 'empty'?
For this moment '' and null are the same in Oracle.
Altough, Oracle says it may change in some futures versions, so if you want
explicit null, use null instead of ''.
Alessandro <supporto_at_tamnet.it> schreef in berichtnieuws
Bacg5.27829$wS2.161354_at_news.infostrada.it...
> My program was developed in VB6-Rdo, i have a question about this type of
> sql command :
>
> INSERT INTO TABLE (ID, Code, Description) VALUES (5,'abc','')
>
> The value result of description field is null but i think that the right
> value must be empty.
>
> I have Oracle version 8.1.6 and I would like to know if that is a bug and
> how I can resolve it.
>
> thanks
>
>
Received on Sat Jul 29 2000 - 00:00:00 CEST