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.Dameng®
Dameng supports the BIT SQL type to store boolean values.
Possible values are 1/0 numbers respectively for true and false boolean values.
Solution
The Dameng BIT type can be used to store BOOLEAN program
variable values.
However, the TRUE/FALSE keywords cannot be used in SQL statements. Review SQL
statements using TRUE/FALSE keywords for boolean columns and replace by 1/0, or use
an SQL parameter for type BOOLEAN.
The
BOOLEAN type translation can be controlled with the
following FGLPROFILE
entry:dbi.database.dsname.ifxemul.datatype.boolean = { true | false }