MySQL Forums
Forum List  »  Docs

Is BIT a datatype? And waht about BOOLEAN?
Posted by: Stan Segers
Date: January 05, 2006 06:20PM

In the chapter 11 of the documentation (version 5.0 & 5.1), I don't see a data type BIT listed. Yet in 9.1.5 BIT is used as a data type. Could BIT be included as a data type in the documentation or isn't it a data type?

As I'm looking at some differences between Microsoft SQL Server 200x and MySQL 5 (and ISO 9075) and noticed the BOOLEAN synonym for TINYINT(1)... for those who know SQL Server, it implements a BOOLEAN data type through BIT (holding only 0, 1 or NULL). Shouldn't BOOLEAN in MySQL not be a synonym for BIT(1)?

My € 0,02 ==> How should -128 evluate? True, False or Unknown?

Options: ReplyQuote


Subject
Views
Written By
Posted
Is BIT a datatype? And waht about BOOLEAN?
15180
January 05, 2006 06:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.