odbc_gettypeinfo
(PHP 4, PHP 5)
odbc_gettypeinfo — Retrieves information about data types supported by the data source
Description
resource odbc_gettypeinfo
( resource
$connection_id
[, int $data_type
] )Retrieves information about data types supported by the data source.
Parameters
-
connection_id -
The ODBC connection identifier, see odbc_connect() for details.
-
data_type -
The data type, which can be used to restrict the information to a single data type.
Return Values
Returns an ODBC result identifier or
FALSE on failure.
The result set has the following columns:
- TYPE_NAME
- DATA_TYPE
- PRECISION
- LITERAL_PREFIX
- LITERAL_SUFFIX
- CREATE_PARAMS
- NULLABLE
- CASE_SENSITIVE
- SEARCHABLE
- UNSIGNED_ATTRIBUTE
- MONEY
- AUTO_INCREMENT
- LOCAL_TYPE_NAME
- MINIMUM_SCALE
- MAXIMUM_SCALE
The result set is ordered by DATA_TYPE and TYPE_NAME.
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Уровни абстракции
- ODBC (Unified)
- odbc_autocommit
- odbc_binmode
- odbc_close_all
- odbc_close
- odbc_columnprivileges
- odbc_columns
- odbc_commit
- odbc_connect
- odbc_cursor
- odbc_data_source
- odbc_do
- odbc_error
- odbc_errormsg
- odbc_exec
- odbc_execute
- odbc_fetch_array
- odbc_fetch_into
- odbc_fetch_object
- odbc_fetch_row
- odbc_field_len
- odbc_field_name
- odbc_field_num
- odbc_field_precision
- odbc_field_scale
- odbc_field_type
- odbc_foreignkeys
- odbc_free_result
- odbc_gettypeinfo
- odbc_longreadlen
- odbc_next_result
- odbc_num_fields
- odbc_num_rows
- odbc_pconnect
- odbc_prepare
- odbc_primarykeys
- odbc_procedurecolumns
- odbc_procedures
- odbc_result_all
- odbc_result
- odbc_rollback
- odbc_setoption
- odbc_specialcolumns
- odbc_statistics
- odbc_tableprivileges
- odbc_tables
Коментарии
Example: display all data types
<?php
$Link_ID = odbc_connect("DSN", "user", "pass");
$result = odbc_gettypeinfo($Link_ID);
odbc_result_all($result);
?>