User Documentation
Ispirer Capabilities - Microsoft SQL Server Migration
Pricing
SQL Server Data Types - BIT
Versions: SQL Server 2008, 2005, 2000, 7.0 and 6.5
SQL Server - BIT | |
---|---|
Syntax | BIT |
Data | Boolean data |
Range | 0, 1 and NULL. String value 'true' is converted to 1 and 'false' is converted to 0 |
Error Handling | Values other than 0 and 1 are accepted but are always interpreted as 1 |
Storage Size | 1 byte for up to 8 bit columns |
Standards | SQL Server Extension |
SQL Server BIT - Equivalents in Other Databases
Database | Data Type and Conversion |
---|---|
MySQL | BOOL, BOOLEAN, -128 to 127 and NULL |
PostgreSQL | BOOLEAN, TRUE/FALSE (1/0) and NULL |
Sybase ASE | BIT, 0 and 1; NULL is not allowed |
Informix | BOOLEAN, 't', 'f' and NULL |
All Data Types