PHP3 Manual
PrevNext

odbc_binmode

odbc_binmode -- handling of binary column data

Description

int odbc_binmode(int result_id, int mode);

(ODBC SQL types affected: BINARY, VARBINARY, LONGVARBINARY)

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

binmodelongreadlenresult
00passthru
10passthru
20passthru
00passthru
0>0passthru
1>0return as is
2>0return 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()


PrevHomeNext
odbc_autocommitUpodbc_close