Re: Oracle datatypes

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: Sun, 02 May 1999 08:58:43 GMT
Message-ID: <372c1177.1272079@news.globalnet.co.uk>

On Thu, 29 Apr 1999 15:12:55 GMT, z_e_n_at_my-dejanews.com wrote:

>Hello,
>
> Someone know how is the better way to represent the boolean (logical)
>datatype in the Oracle 8.
>

Traditionally you would use a varchar2(1) column with values Y or N - it is easy to read in queries etc.

For use with VB I prefer number(1) with -1 and 0 as these can be fetched into a boolean variable directly. Received on Sun May 02 1999 - 03:58:43 CDT