Forum : difference between BOOL, TINYINT and BIT.
Brief description  about Online courses   join in Online courses
View prabeen  patra 's Profile

difference between BOOL, TINYINT and BIT.

hi,
what is the difference between BOOL, TINYINT and BIT?, any one can reply.
Asked by prabeen patra | Mar 12, 2010 |  Reply now
Replies (1)
View teacher siliconindia 's Profile
Mr.Prabeen, Prior to MySQL 5.0.3: those are all synonyms. after that,
BOOL: Used to store Boolean values, 0 being false and 1 being true. MySQL sets them as TINYINT type.
TINYINT: The range of this data type is -128 to +127 or 0 to 256 and occupies 1 byte.
BIT: Bit uses 8 bytes and stores only binary data.
Mar 12, 2010