At 10:06 PM -0500 9/20/99, Martin Ramsch wrote:
>On Mon, 1999-09-20 09:56:51 -0700, Nathan Clegg wrote:
>> I noticed that 'bool' is a reserved word, but that there are no
>> boolean column types. Is tinyint the most efficient way to store a
>> single boolean value?
>IMHO yes! Only ENUM with up to 256 values, e.g. ENUM('Y','N'), is
>equally good and only needs 1 byte, too.
As of MySQL, you can also use CHAR(0) to store boolean values. Declare
it NULL, and the column can be either NULL or the empty string (in effect,
NULL or NOT NULL).
It's very efficient in terms of storage. :-)
Paul DuBois, paul@stripped