BOOLEAN data type

Informix® supports the BOOLEAN data type, which can store 't' or 'f' values. Genero BDL implements the BOOLEAN data type in a different way. As in other programming languages, Genero BOOLEAN stores 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.

SQLite does not implement a native BOOLEAN type, but accepts BOOLEAN in the SQL syntax.

Solution

The SQLite database interface supports the BOOLEAN data type, and converts the BDL BOOLEAN integer values to a CHAR(1) of '1' or '0'.