Re: Nullology of empty strings

usenet_at_kikobu.com (Morten) writes:

> Hi. I'm curious about why the empty string '' IS NULL in Oracle databases.
> Is this a general convention? Where can I read up on the theory behind this?
>
> I would like to find out why this is so, and what the theoretical foundations
> are (relational calculus possibly?)
>

I think this is just a quirk of Oracle. Other systems I have used do not treat '' as NULL. Also, according to some oracle documentation I have seen, the '' as NULL in oracle is not guaranteed to be kept in future versions. I find this a frustrating situation personally.

Tim

-- 
Tim Cross
The e-mail address on this message is FALSE (obviously!). My real e-mail is
to a company in Australia called rapttech and my login is tcross - if you 
really need to send mail, you should be able to work it out!