Download Informix CLI Programmer`s Manual, Version 2.8

Converting Data from C to SQL
When character C data is converted to binary SQL data, each 2 bytes of
character data are converted to a single byte (8 bits) of binary data. Each 2
bytes of character data represent a number in hexadecimal form. For
example, “01” is converted to a binary 00000001 and “FF” is converted to a
binary 11111111.
The driver always converts pairs of hexadecimal digits to individual bytes
and ignores the null-termination byte. Because of this conversion, if the
length of the character string is odd, the last byte of the string (excluding the
null termination byte, if any) is not converted.
IUS
Additional C-to-SQL Character Data Conversion for Universal Server
The following table shows the additional INFORMIX-CLI SQL data types for
Universal Server to which character C data can be converted.
fSqlType
Test
SQLSTATE
SQL_BIGINT
Data converted without truncation.
N/A
Data converted with truncation of fractional digits.
01004
Conversion of data would result in loss of whole (as
opposed to fractional) digits.
22003
Data value is not a numeric-literal.
22005
Data is 0 or 1.
N/A
Data is greater than 0, less than 2, and not equal to 1.
01004
Data is less than 0 or greater than or equal to 2.
22003
Data is not a numeric-literal.
22005
SQL_BIT
♦
B-34 INFORMIX-CLI Programmer’s Manual