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® MySQL and MariaDB
MySQL supports the BOOLEAN type name as an alias for the built-in
TINYINT(1) data type.
Colums defined as BOOLEAN or TINYINT(1) can store
1 or 0 integer values for TRUE and
FALSE.
Solution
The MySQL and MariaDB database interfaces support the BOOLEAN data type 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 }