A_ODBC_USE_CHAR_FOR_BINARY

Some data sources have restrictions on the number of binary large objects (BLOBs) that can be placed into a single table. If your data source has such restrictions, specify A_ODBC_USE_CHAR_FOR_BINARY in the configuration file. The possible values for this variable are:

If A_ODBC_USE_CHAR_FOR_BINARY is set to a nonzero value, you can store data that uses the BINARY directive as hexadecimal encoded CHAR types. This allows you to work around your data source restriction. The default value is 0 (or OFF, FALSE, or NO), This configuration variable can also take values of ON, TRUE, or YES.

For example:

A_ODBC_USE_CHAR_FOR_BINARY 1