Re: best way to stare true, false

From: 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

« previous php.db (#21116) next »