Ispirer Ispirer
 


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

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


Ispirer Home Page Ispirer SQLWays Product Page - Informix Migration Request SQLWays

sqlways/informix/data-types/boolean.txt · Last modified: May 07, 2018, 03:15:26 PM (external edit)
 
© 1999-2021, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement