Re: best way to stare true, false
| From: | leo g. divinagracia iii | Date: | Mon, 12 Aug 2002 21:03:56 +0000 |
| Subject: | Re: best way to stare true, false | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-21116@lists.php.net to get a copy of this message | ||
if you are storing a bunch of T/F, you can store 8 of them into a single
byte... each bit position will represent one "question"...
you just have to do some BIT manipulation on your end...
andy wrote:
> Hi there,
>
> I am searching for the best way to store true or false inside a MySQL DB.
> With best I mean the most data efficient way and in the same time the best
> for fast searching later on the table to find all which are false, or true.
> I think I did read something about a way to do this with ENUM, but cant
> remember where and how, all tryes did not succeeed so far.
>
>
--
Leo G. Divinagracia III
ldivinag@csuhayward.edu