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
Sybase ASE BIT, 0 and 1; NULL is not allowed
Informix BOOLEAN, 't', 'f' and NULL

All Data Types

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.