Example: display all data types
<?php
$Link_ID = odbc_connect("DSN", "user", "pass");
$result = odbc_gettypeinfo($Link_ID);
odbc_result_all($result);
?>
odbc_gettypeinfo
(PHP 4, PHP 5)
odbc_gettypeinfo -- Returns a result identifier containing information about data types supported by the data sourceDescription
resource odbc_gettypeinfo ( resource connection_id [, int data_type] )Retrieves information about data types supported by the data source. Returns an ODBC result identifier or FALSE on failure. The optional argument data_type can be used to restrict the information to a single data type.
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.
add a note
User Contributed Notes
andrea dot galli at acotel dot com
30-Apr-2003 12:45
30-Apr-2003 12:45