odbc_gettypeinfo()
(PHP 4, PHP 5, PHP 7)
Retrieves information about data types supported by the data source
说明
odbc_gettypeinfo(resource $connection_id[,int $data_type]): resource
Retrieves information about data types supported by the data source.
参数
- $connection_id
ODBC 连接标识符,详见odbc_connect()。
- $data_type
The data type, which can be used to restrict the information to a single data type.
返回值
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.
Example: display all data types <?php $Link_ID = odbc_connect("DSN", "user", "pass"); $result = odbc_gettypeinfo($Link_ID); odbc_result_all($result); ?>