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