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

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to