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.PostgreSQL
PostgreSQL supports the BOOLEAN data type and stores 't' or
'f' values for TRUE and FALSE representation.
Note: It is not possible to insert the integer values
1 or 0 into
PostgreSQL BOOLEAN columns: Values must be true,
false, 't', 'f', '1' or
'0'.Solution
The PostgreSQL database interface converts the BOOLEAN integer values to a
CHAR(1) values '1' or '0'.
The
BOOLEAN type translation can be controlled with the
following FGLPROFILE
entry:dbi.database.dsname.ifxemul.datatype.boolean = { true | false }