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.