BOOLEAN data type

Informix®

Informix supports the BOOLEAN data type, which can store 't' or 'f' values.

Genero BDL implements the BOOLEAN data type in a different way: A BOOLEAN variable stores integer values 1 or 0 (for TRUE or FALSE). This type is designed to hold the result of a boolean expression.

ORACLE

Oracle does not implement a native BOOLEAN type in SQL types.

However, a BOOLEAN type exists in the PL/SQL language.

Solution

The Oracle database interface converts the BOOLEAN type to CHAR(1) columns and stores '1' or '0' values in the column.

The BOOLEAN type translation can be controlled with the following FGLPROFILE entry:
dbi.database.dsname.ifxemul.datatype.boolean = { true | false }
For more details see IBM Informix emulation parameters in FGLPROFILE.