Ispirer Website Ispirer Capabilities - Sybase Migration Free Trial

Sybase ASE Data Types - BIT

Versions: Sybase Adaptive Server Enterprise 15.x, 12.5.x, 12.0 and 11.x

Sybase ASE - BIT
Syntax BIT
Data Boolean data
Range 0 and 1 only (NULL is not allowed)
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 Sybase Transact-SQL Extension

Sybase ASE BIT - Equivalents in Other Databases

Database Data Type and Conversion
SQL Server BIT, 0 or 'false', 1 or 'true' and NULL
MySQL BOOL, BOOLEAN, -128 to 127 and NULL
Informix BOOLEAN, 't', 'f' and NULL

All Data Types

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