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.SAP ASE
SAP® ASE provides the BIT
data type to store boolean values.
However, unlike Informix types, BIT
columns cannot be NULL and thus you must specify the NOT NULL
constraint when creating the table.
Solution
The SAP ASE database interface converts
BOOLEAN type to BIT columns and stores 1 or
0 values in the column.
You must explicitly specify the NOT NULL constraint in the CREATE
TABLE statement.
The
BOOLEAN type translation can be controlled with the
following FGLPROFILE
entry:dbi.database.dsname.ifxemul.datatype.boolean = { true | false }