bitfields in table

hi!

lets assume an entity with many boolean attributes, eg a table with many columns of type CHAR(1) containing 0/1; i think that there is a limit in the number of boolean columns, until which it is useful to represent these bits as one char each;

what is the best way to store and query these "bitfields"? storing 8 bits in one char and writing external c-procedures to do the bit-manipulations?
this seems to be quite uncomfortable to me! and what is this limit in the numbers of "bits" per row? 10? 1000?

thanx,
mitt Received on Fri Jan 28 2000 - 08:53:00 CST