clever storage?

[Icoolerthnu]

im creating the database to store information from several forms for a class. One form contains about 30 checkboxes which give yes or no information. anyone got a clever way to store this besides like 30 bool collums in a table... (i dont know why that just seems...crude =D)

 

[skiflyer]

considering booleans can be implemented as a single bit, it's very not crude actually... about as efficient as you can get. I'm not positive mySQL does booleans like this, if not there's a good chance it has a bit field you can use that.

-Rob

 

[danielhozac]

Depending on your language, you should be able to serialize the data (in an array for example) and then later retrieve the data and unserialize it. I use this in a number of situations. //Daniel