List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:September 21 1999 3:06am
Subject:Re: boolean values?
View as plain text  
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.

> What is 'bool' used for?

No idea.

Martin Ramsch <m.ramsch@stripped> <URL: >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
boolean values?Nathan Clegg20 Sep
  • Re: boolean values?Martin Ramsch21 Sep
    • Re: boolean values?Paul DuBois21 Sep
    • Re: boolean values?Paul DuBois21 Sep
  • boolean values?Michael Widenius22 Sep