Re: Bug NULL ???
From: Matt B. <mcb_at_fightspam.sd.znet.com>
Date: 2000/07/28
Message-ID: <so4s426co0b35_at_corp.supernews.com>#1/1
Date: 2000/07/28
Message-ID: <so4s426co0b35_at_corp.supernews.com>#1/1
"Alessandro" <supporto_at_tamnet.it> wrote in message
news: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
Oracle treats both null and the empty string as null.
-Matt Received on Fri Jul 28 2000 - 00:00:00 CEST