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.

Sybase ASE provides the BIT data type to store boolean values. However, unlike Informix types, BIT columns cannot be NULL and thus you must specify the NOT NULL constraint when creating the table.

Solution

The Sybase ASE database interface converts BOOLEAN type to BIT columns and stores 1 or 0 values in the column.

You must explicitly specify the NOT NULL constraint in the CREATE TABLE statement.