User Documentation
Ispirer Capabilities - Informix Migration
Pricing
Informix Dynamic Server (IDS) Data Types - BOOLEAN
Versions: Informix Dynamic Server 11.x, 10.x, 9.x and 7.x
| Informix - BOOLEAN | |
|---|---|
| Syntax | BOOLEAN |
| Data | Boolean data |
| Range | 't', 'f' and NULL. 't' represents TRUE logical value, 'f' represents FALSE. Values are not case-sensitive, 't' is equivalent to 'T', 'f' to 'F' |
| Standards | Informix SQL Extension |
Example:
CREATE TABLE t_boolean (c1 BOOLEAN);
Informix BOOLEAN - 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 |
| Sybase ASE | BIT, 0 and 1; NULL is not allowed |
All Data Types