BitData CLI/ODBC and IBM data server driver configuration keyword
Specifies whether binary data types are reported as binary or character data types.
- db2cli.ini keyword syntax:
- BitData = 1 | 0
- IBM® data server driver configuration file (db2dsdriver.cfg) syntax:
- <parameter name=“BitData" value=“1 | 0"/>
Attention: The IBM data server
driver configuration
file (db2dsdriver.cfg) syntax is available in Db2 11.5.4 and later.
- Default setting:
- Report
FOR BIT DATAand 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® 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 DATAand BLOB data types as binary data types (default). - 0 = report
FOR BIT DATAand BLOB data types as character data types.