Hi,

I'm looking to store permissions in a table in MySQL. I was thinking of using somthing similar to Linux permissions, i.e. a binary representation. The size of the field will obviously be minimal, 8bits ish...

Whats the best way of storing this data? The blob type fields look a little overkill, or do they 'shrink to fit' like Levis... lol.

Thanks.

don't mess around, disk space is not as expensive as it used to be back in the mainframe days

use TINYINT for 0/1 values

but i like messing around it's fun lol.

I;m gonna have to ask, you seem to answer every1s questions here, do you ever sleep? or is your brain wired to the web? lol

Thanks for continued input and general all round helpfulness!!!

i sleep in between posts