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