Is BIT a datatype? And waht about BOOLEAN?
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?
Subject
Views
Written By
Posted
Is BIT a datatype? And waht about BOOLEAN?
15096
January 05, 2006 06:20PM
6743
January 06, 2006 02:55PM
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.