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 |
| PostgreSQL | BOOLEAN, TRUE/FALSE (1/0) and NULL |
| Informix | BOOLEAN, 't', 'f' and NULL |
All Data Types