DB2 Version 9.7 for Linux, UNIX, and Windows

BitData CLI/ODBC configuration keyword

Specifies whether binary data types are reported as binary or character data types.

db2cli.ini keyword syntax:: BitData = 1 | 0
Default setting:: Report FOR BIT DATA and BLOB data types as binary data types.
Usage notes:

This option allows you to specify whether ODBC binary data types (SQL_BINARY, SQL_VARBINARY, SQL_LONGVARBINARY, and SQL_BLOB), are reported as binary type data. IBM® DBMSs support columns with binary data types by defining CHAR, VARCHAR, and LONG VARCHAR columns with the FOR BIT DATA attribute. DB2® for Linux, UNIX, and Windows will also support binary data via the BLOB data type (in this case it is mapped to a CLOB data type).

Only set BitData = 0 if you are sure that all columns defined as FOR BIT DATA or BLOB contain only character data, and the application is incapable of displaying binary data columns.

1 = report FOR BIT DATA and BLOB data types as binary data types (default).
0 = report FOR BIT DATA and BLOB data types as character data types.