Programming Forums - View Single Post

Sane · Jul 26th, 2006, 9:40 PM

Is there any datatype for MySQL that can hold 2 Bits... or as close to three possible values as possible... without going over? I need to be able to hold the values 0/1/2. I'm currently using an int, but since there are 6000 of them, I thought it might help if I used something smaller.

Jul 26th, 2006, 9:40 PM	#1
Sane Programming Guru Join Date: Apr 2005 Posts: 1,827 Rep Power: 5	MySQL Datatypes: 2 Bits? Is there any datatype for MySQL that can hold 2 Bits... or as close to three possible values as possible... without going over? I need to be able to hold the values 0/1/2. I'm currently using an int, but since there are 6000 of them, I thought it might help if I used something smaller.