| SQL adaptation guide For Genero db 3.6x, 3.8x / Data dictionary | |
Informix® supports the BOOLEAN data type, which can store 't' or 'f' values. Genero BDL implements the BOOLEAN data type as in other programming languages, storing integer values 1 or 0 (for TRUE or FALSE). The type was designed this way to assign the result of a boolean expression to a BOOLEAN variable.
Genero db 3.60 supports a BOOLEAN type which can store the following values (case-insensitive): TRUE/FALSE or 1/0. You can't use the 't' or 'f' character values as in Informix.
The Genero db database interface supports the BOOLEAN data type.