Jump to content


MySQL Column Choice

  • Please log in to reply
1 reply to this topic

#1 Matias

  • Members
  • Pip
  • Newbie
  • 7 posts

Posted 25 December 2005 - 09:24 PM

ok lets say there was database that consisted of switchboard values (on or off)

column 1 (0 or 1)
column 2 (0 or 1)
column 3 (0 or 1)
column 4 (0 or 1)
column 5 (0 or 1)
column 6 (0 or 1)

now all of those are what they are (they define what is activated)

anyways right now they have their own correctponding colums, but I want to make them into one line of numbers...

so something like this


pretty much like chmod only its binary...

now which way would be best to do so. Should I make a column that is CHAR(6) or should I make a MEDIUMINT(6) colum.

Or if its possible, can a BIT column be made, so its binary

which way is better

#2 fenway

  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 25 December 2005 - 11:15 PM

AFAIK, they did add a BIT column type in MySQL 5, so obviously, that would be ideal. In pre-5, I would suspect the INT columns would be better suited, but you can always check the relevant [a href=\"http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html\" target=\"_blank\"]refman page[/a] that discusses column storage requirements.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users