Re: storing boolean value

From: Daniel A. Morgan <Daniel.Morgan_at_attws.com>
Date: Thu, 19 Jul 2001 13:44:52 -0700
Message-ID: <3B5746C4.E09F855E@attws.com>

Christof Kaiser wrote:

> Btw:
> is there any reason why Oracle does not support booleans?
> That looks quite stupid to me.
> Especially if they provide functions (such as in Spatial) which return a
> boolean.
> Great Oracle technology is to pass back a string, which is either 'TRUE'
> or 'FALSE'.
>
> Just hope you get the spelling right when processing the result...
>
> christof

I don't know. But perhaps because no product stores Booleans. They just store 0 and 1 and go through a translation step.

Have you considered just defining constants?

Daniel A. Morgan Received on Thu Jul 19 2001 - 15:44:52 CDT