DisableBinaryDataSupport IBM data server driver configuration keyword
Specifies whether binary data types are reported as binary or character data types.
- Equivalent CLI keyword
- BitData
- Equivalent IBM® Data Server Provider for .NET connection string keyword
- N/A
- db2dsdriver.cfg configuration syntax
<parameter name="DisableBinaryDataSupport" value="0 | 1"/>- 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 DATAattribute. Db2 will also support binary data via the BLOB data type (in this case it is mapped to a CLOB data type).Only set DisableBinaryDataSupport = 1 if you are sure that all columns defined as
FOR BIT DATAor BLOB contain only character data, and the application is incapable of displaying binary data columns.- 0 = report
FOR BIT DATAand BLOB data types as binary data types (default). - 1 = report
FOR BIT DATAand BLOB data types as character data types.
- 0 = report