Re: [PHP-DB] best way to stare true, false

2002-08-12 Thread leo g. divinagracia iii
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

Re: [PHP-DB] best way to stare true, false

2002-08-11 Thread Andy
oh... no I ment it in a different way.. somehow.. declare 1 enum value and then set it or not. Search for NULL or not NULL values instead of false /true. in this direction, but .. hey does nobody do this like that?? Andy --

Re: [PHP-DB] best way to stare true, false

2002-08-11 Thread Jim Hunter
The smallest amount of database storage is going to be with a TinyInt and if you set up two constants to represent TRUE and FALSE then all your code will read correctly and will store correctly. EG: define(TRUE, 1); define(FALSE, 0); now you can use TRUE and FALSE in your program where you

Re: [PHP-DB] best way to stare true, false

2002-08-10 Thread Raquel Rice
On Sat, 10 Aug 2002 16:46:54 +0200 andy [EMAIL PROTECTED] 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

Re: [PHP-DB] best way to stare true, false

2002-08-10 Thread andy
hmm.. thats how I am doing it right now. There might be a better way?! Raquel Rice [EMAIL PROTECTED] schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... On Sat, 10 Aug 2002 16:46:54 +0200 andy [EMAIL PROTECTED] wrote: Hi there, I am searching for the best way to

Re: [PHP-DB] best way to stare true, false

2002-08-10 Thread Raquel Rice
On Sat, 10 Aug 2002 17:41:56 +0200 andy [EMAIL PROTECTED] 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