ODBC_BINMODE(3) 1 ODBC_BINMODE(3)odbc_binmode - Handling of binary column dataSYNOPSIS
bool odbc_binmode (resource $result_id, int $mode)
DESCRIPTION
Enables handling of binary column data. ODBC SQL types affected are BINARY, VARBINARY, and 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".
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(3) is used, passthru means that an empty string is returned for these columns.
PARAMETERS
o $result_id
- The result identifier. If $result_id is 0, the settings apply as default for new results.
Note
Default for longreadlen is 4096 and $mode defaults to ODBC_BINMODE_RETURN. Handling of binary long columns is also affected
by odbc_longreadlen(3).
o $mode
- Possible values for $mode are:
o ODBC_BINMODE_PASSTHRU: Passthru BINARY data
o ODBC_BINMODE_RETURN: Return as is
o ODBC_BINMODE_CONVERT: Convert to char and return
RETURN VALUES
Returns TRUE on success or FALSE on failure.
PHP Documentation Group ODBC_BINMODE(3)
Check Out this Related Man Page
DB2_COLUMNS(3) 1 DB2_COLUMNS(3)db2_columns - Returns a result set listing the columns and associated metadata for a tableSYNOPSIS
resource db2_columns (resource $connection, [string $qualifier], [string $schema], [string $table-name], [string $column-name])
DESCRIPTION
Returns a result set listing the columns and associated metadata for a table.
PARAMETERS
o $connection
- A valid connection to an IBM DB2, Cloudscape, or Apache Derby database.
o $qualifier
- A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string.
o $schema
- The schema which contains the tables. To match all schemas, pass '%'.
o $table-name
- The name of the table or view. To match all tables in the database, pass NULL or an empty string.
o $column-name
- The name of the column. To match all columns in the table, pass NULL or an empty string.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the columns matching the specified parameters. The rows are com-
posed of the following columns:
+------------------+---------------------------------------------------+
| Column name | |
| | |
| | Description |
| | |
+------------------+---------------------------------------------------+
| TABLE_CAT | |
| | |
| | Name of the catalog. The value is NULL if this |
| | table does not have catalogs. |
| | |
| TABLE_SCHEM | |
| | |
| | Name of the schema. |
| | |
| TABLE_NAME | |
| | |
| | Name of the table or view. |
| | |
| COLUMN_NAME | |
| | |
| | Name of the column. |
| | |
| DATA_TYPE | |
| | |
| | The SQL data type for the column represented as |
| | an integer value. |
| | |
| TYPE_NAME | |
| | |
| | A string representing the data type for the col- |
| | umn. |
| | |
| COLUMN_SIZE | |
| | |
| | An integer value representing the size of the |
| | column. |
| | |
| BUFFER_LENGTH | |
| | |
| | Maximum number of bytes necessary to store data |
| | from this column. |
| | |
| DECIMAL_DIGITS | |
| | |
| | The scale of the column, or NULL where scale is |
| | not applicable. |
| | |
| NUM_PREC_RADIX | |
| | |
| | An integer value of either 10 (representing an |
| | exact numeric data type), 2 (representing an |
| | approximate numeric data type), or NULL (repre- |
| | senting a data type for which radix is not appli- |
| | cable). |
| | |
| NULLABLE | |
| | |
| | An integer value representing whether the column |
| | is nullable or not. |
| | |
| REMARKS | |
| | |
| | Description of the column. |
| | |
| COLUMN_DEF | |
| | |
| | Default value for the column. |
| | |
| SQL_DATA_TYPE | |
| | |
| | An integer value representing the size of the |
| | column. |
| | |
|SQL_DATETIME_SUB | |
| | |
| | Returns an integer value representing a datetime |
| | subtype code, or NULL for SQL data types to which |
| | this does not apply. |
| | |
|CHAR_OCTET_LENGTH | |
| | |
| | Maximum length in octets for a character data |
| | type column, which matches COLUMN_SIZE for sin- |
| | gle-byte character set data, or NULL for non- |
| | character data types. |
| | |
|ORDINAL_POSITION | |
| | |
| | The 1-indexed position of the column in the ta- |
| | ble. |
| | |
| IS_NULLABLE | |
| | |
| | A string value where 'YES' means that the column |
| | is nullable and 'NO' means that the column is not |
| | nullable. |
| | |
+------------------+---------------------------------------------------+
SEE ALSO db2_column_privileges(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_special_columns(3),
db2_statistics(3), db2_table_privileges(3), db2_tables(3).
PHP Documentation Group DB2_COLUMNS(3)