Ispirer Website
Ispirer Capabilities - Microsoft SQL Server Migration
Free Trial
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