Re: Implementation of boolean types.

You missed the class on scales and measurements. SQL deliberately left out Booleans and deprecated bits. They are a sign of "punch card" and assembly language programming.

>> I personally think that this should be design using a relationship with other tables such as Human <<

No, you should use a CHECK() on a vlaue that is limited to a particular scale.

Your sex code example has an ISO Standard which you would have found if you researched before you coded. 0= Unknown, 1= male, 2= female and 9= lawful person (corporations, organizations, etc.)

Get a copy of SQL PROGRAMMING STYLE for some details on how to create encoding schemes -- there is no single magic answer. Received on Wed Jul 13 2005 - 19:42:19 CDT