Explain the difference between BOOL, TINYINT and BIT. ? - MySQL Forum Discussion

Siliconindia

Courses

Web developer : Course content | How it works | Benefits | Tutorials | Forum | Register | My class

Become a certified PHP/MySQL developer

Main home > Discussion board > MySQL

Discussion board

+Start new topic

Explain the difference between BOOL, TINYINT and BIT. ?

By prabeen patra

Explain the difference between BOOL, TINYINT and BIT.??

Reply

Post Reset

Teacher SiliconIndia replied to prabeen patra Thursday, March 18, 2010

Hi Prabeen,
Prior to MySQL 5.0.3: those are all synonyms. After MySQL 5.0.3: BIT data type can store 8 bytes of data and should be used for binary data.

Click here to view more answers

All courses