int odbc_binmode(int result_id, int mode);(ODBC SQL types affected: BINARY, VARBINARY, LONGVARBINARY)
0: Passthru BINARY data
1: Return as is
2: Return and convert to char
When binary SQL data is converted to character C data, each byte (8 bits) of source data is represented as two ASCII characters. These characters are the ASCII character representation of the number in its hexadecimal form. For example, a binary 00000001 is converted to "01" and a binary 11111111 is converted to "FF".
Table 1. LONGVARBINARY handling
| binmode | longreadlen | result |
|---|---|---|
| 0 | 0 | passthru |
| 1 | 0 | passthru |
| 2 | 0 | passthru |
| 0 | 0 | passthru |
| 0 | >0 | passthru |
| 1 | >0 | return as is |
| 2 | >0 | return as char |
* if odbc_fetch_into is used, passthru means that an empty string * is returned for these columns.
If result_id is 0, the settings apply as default for new results.
NOTE: Default for longreadlen is 4096 and binmode defaults to 1. Handling of binary Long columns is also affected by odbc_longreadlen()