Ispirer Website Ispirer Capabilities - Informix Migration Free Trial

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


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