Re: Implementation of boolean types.
From: -CELKO- <jcelko212_at_earthlink.net>
Date: 13 Jul 2005 17:42:19 -0700
Message-ID: <1121301739.723694.306960_at_g14g2000cwa.googlegroups.com>
Date: 13 Jul 2005 17:42:19 -0700
Message-ID: <1121301739.723694.306960_at_g14g2000cwa.googlegroups.com>
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.
No, you should use a CHECK() on a vlaue that is limited to a particular scale.
Get a copy of SQL PROGRAMMING STYLE for some details on how to create encoding schemes -- there is no single magic answer. Received on Thu Jul 14 2005 - 02:42:19 CEST