Programming Forums > Web Development and Design > PHP

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.

Jimbo · Jul 27th, 2006, 2:08 AM

From http://dev.mysql.com/doc/refman/5.0/...ric-types.html:

Quote:

As of MySQL 5.0.3, a BIT data type is available for storing bit-field values. (Before 5.0.3, MySQL interprets BIT as TINYINT(1).) In MySQL 5.0.3, BIT is supported only for MyISAM. MySQL 5.0.5 extends BIT support to MEMORY, InnoDB, and BDB

On the storage requirements page though, it says BIT(M) is stored in (M+7)/8 bytes, so it's about the same as a TINYTINT

Jul 26th, 2006, 9:40 PM	#1
Sane Programming Guru Join Date: Apr 2005 Posts: 1,799 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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MySQL with python?	snipertomcat	Python	2	Apr 13th, 2006 1:34 AM
Tutorial - Using MySQL in C#	Darkhack	C#	12	Jan 17th, 2006 9:28 AM
Simple Perl / MySQL Problem.. pls help!	domquemo	Perl	0	Jan 11th, 2006 4:08 AM
Php, Mysql, Perl	scorpiosage	Other Web Development Languages	0	Jul 3rd, 2005 9:47 PM
Problem Inserting Values into mySQL from PHP	stakeknife	PHP	1	Mar 23rd, 2005 8:45 AM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Programming Forums > Web Development and Design > PHP

MySQL Datatypes: 2 Bits?