| SQL adaptation guide for SQL SERVER 2005, 2008, 2012, 2014, 2016 / Data dictionary | |
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.
SQL SERVER provides the BIT data type to store boolean values.
The SQL SERVER database interfaces converts BOOLEAN type to BIT columns and stores 1 or 0 values in the column.