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"...
Advertising
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 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
