[PHP] Bit-flags in tables?

2001-07-11 Thread Lasse


Ok, after a lot of R'ing TFM, I'm more confused than I was before... Seems
MySQL plays pretty loose with most datatypes and stores half the numeric
types as strings, so

I want e.g. a 16 bit field where I can use the individual bits for various
flags. How should I set the MySQL datatype and attributes?

Also, are there any other caveats I should know about? (e.g. PHP's handling
of integers)

Back in the good ol' 680x0 ASM days this was so easy! :-)

TIA
--
Lasse




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]




RE: [PHP] Bit-flags in tables?

2001-07-11 Thread Don Read


On 11-Jul-01 Lasse wrote:
 
 Ok, after a lot of R'ing TFM, I'm more confused than I was before... Seems
 MySQL plays pretty loose with most datatypes and stores half the numeric
 types as strings, so
 
 I want e.g. a 16 bit field where I can use the individual bits for various
 flags. How should I set the MySQL datatype and attributes?
 

SMALLINT UNSIGNED
 also look at SET

 Also, are there any other caveats I should know about? (e.g. PHP's handling
 of integers)
 

32bit signed (should be ok).

 Back in the good ol' 680x0 ASM days this was so easy! :-)

M6502, 8080 , sticks  rocks for ones  zeros.
 Funny, i don't feel like an old fart (yet).

Regards,
-- 
Don Read   [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to 
   steal the neighbor's newspaper, that's the time to do it.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]