BOOLEAN data type
Informix®
Informix supports the BOOLEAN data type, which can store 't' or 'f'
values.
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 }