The bit datatype is used for Boolean values:
bit – either 1 or 0. Integer values other than 1 or 0 are interpreted as 1.
The output of a bit datatype is
in hex, a format that is invalid for IQ. To get a numeric value
instead of a hex representation, use a published datatype of integer or tinyint.