title: How to store a multiple choice useful in a database?
body: <p>this is all about how to store content in the most efficient way in a database.
  The most important thing here is not to save as much space as possible - the focus lays on the fastest way to use this data.</p>
  
  <p>So in general its an easy thing :</p>
  
  <p>We have 10 choices with radio boxes - we can select ALL or we can select none - or just select one/some of 'em.</p>
  
  <p>So in general I see two general options to save the result in my database :</p>
  
  <p>A) Just make 10 Fields on my table with Tinyint(1) and set a 0 or 1</p>
  
  <p>B) I could use ONE Int(7) which will have the chance to decode the result like a binary system - f.E. if you choose option 3, 5 &amp; 8 its like 00101001.</p>
  
  <p>So the question is which makes more sense ?</p>
  
  <p>B will take only 4 Bytes and A will take 8 Bytes - besides B will need a short PHP function to decode the binary thing.</p>
  
  <p>The question now what option do you think will be of better usage sooner or later if the database get a hell of querys ?</p>