What is the difference between BIT and TINYINT in MySQL?

mysql bit tinyint
carrier picture carrier · Nov 14, 2008 · Viewed 113.1k times · Source

In which cases would you use which? Is there much of a difference? Which I typically used by persistence engines to store booleans?

Answer

Robert Gamble picture Robert Gamble · Nov 14, 2008

A TINYINT is an 8-bit integer value, a BIT field can store between 1 bit, BIT(1), and 64 bits, BIT(64). For a boolean values, BIT(1) is pretty common.

Related questions

What value could I insert into a bit type column?

I am trying to insert or edit the bit value to "0" or "1", but either returns me a blank. Could someone tells me how to insert the value in it? Also, Is that possible to not use bit type but Boolean? …

Read More
Mysql: How to query a column whose type is bit?

Hi I am using hibernate and Mysql. I have a class with a boolean attribute called 'active'. The generated database table has the BIT data type. So far so good. I want to query this value but I don't know …

Read More
Can't see MySQL BIT field value when using SELECT

my_table contains the enabled field which is defined as: enabled BIT NOT NULL DEFAULT 0. This table has multiple rows with enabled = b'0', and multiple rows with enabled = b'1'. However, both this: SELECT * from my_table WHERE enabled = …

Read More