Re: Implementation of boolean types.

Matthias Hoys wrote:
>
> I would use a CHAR(1) column with a check constraint ('0' or '1').
> You could then link the table to a small lookup table with the description
> of the 0 and 1.
> 0 = male
> 1 = female
>

No.
That would be '0' for male, and '1' for female. Character strings!

Why would you use a depericated char datatype, and not a number?

-- 
Regards,
Frank van Bortel