   #PHP Manual Unified ODBC functions odbc_autocommit odbc_close_all

   PHP Manual
   Prev  Next
   ______________________________________________________________________

                                 odbc_binmode

   (PHP 3>= 3.0.6, PHP 4 )
   odbc_binmode -- Handling of binary column data

Description

   int odbc_binmode ( resource result_id, int mode)

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

     * ODBC_BINMODE_PASSTHRU: Passthru BINARY data
     * ODBC_BINMODE_RETURN: Return as is
     * ODBC_BINMODE_CONVERT: Convert to char and return

   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
   ODBC_BINMODE_PASSTHRU 0           passthru
   ODBC_BINMODE_RETURN   0           passthru
   ODBC_BINMODE_CONVERT  0           passthru
   ODBC_BINMODE_PASSTHRU 0           passthru
   ODBC_BINMODE_PASSTHRU >0          passthru
   ODBC_BINMODE_RETURN   >0          return as is
   ODBC_BINMODE_CONVERT  >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
     ODBC_BINMODE_RETURN. Handling of binary long columns is also
     affected by odbc_longreadlen()
   ______________________________________________________________________

   Prev            Home           Next
   odbc_autocommit  Up  odbc_close_all
