Re: [PHP-DB] best way to stare true, false
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 [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] best way to stare true, false
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
--
http://www.globosapiens.net
Global Travellers Network!
Raquel Rice [EMAIL PROTECTED] schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
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 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.
Thanx for any help on that.
Andy
How about as a tinyint ... 0/1
--
Raquel
hmm.. thats how I am doing it right now. There might be a better
way?!
I've never used ENUM, so take what I say with a grain of salt. It
appears to me that if you use true or false as your ENUM values,
those values are stored as strings. In PHP you would then have to
do string comparisons rather that
if ($a) {
do this;
}
Perhaps it depends upon how you use it ... what you do with it?
--
Raquel
The world is not good enough - we must make it better.
--Alice Walker
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] best way to stare true, false
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 would use any variable (just don't use a dollar sign in front of them). This will make your code much easier to read in the long run. Plus, if you create a 'master global' file with all of your custom routines that you use in all programs, you could have these globals there as well avaialable to all your programs without thinking about it again. Remember, keep your code readable, runable and reusable! Jim Hunter Diamond Computing ---Original Message--- From: andy Date: Saturday, August 10, 2002 07:40:19 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] best way to stare true, false 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. Thanx for any help on that. Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php .
[PHP-DB] best way to stare true, false
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. Thanx for any help on that. Andy -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] best way to stare true, false
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 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. Thanx for any help on that. Andy How about as a tinyint ... 0/1 -- Raquel The world is not good enough - we must make it better. --Alice Walker -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] best way to stare true, false
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 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. Thanx for any help on that. Andy How about as a tinyint ... 0/1 -- Raquel The world is not good enough - we must make it better. --Alice Walker -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] best way to stare true, false
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 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.
Thanx for any help on that.
Andy
How about as a tinyint ... 0/1
--
Raquel
hmm.. thats how I am doing it right now. There might be a better
way?!
I've never used ENUM, so take what I say with a grain of salt. It
appears to me that if you use true or false as your ENUM values,
those values are stored as strings. In PHP you would then have to
do string comparisons rather that
if ($a) {
do this;
}
Perhaps it depends upon how you use it ... what you do with it?
--
Raquel
The world is not good enough - we must make it better.
--Alice Walker
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
