Edit Report a Bug

odbc_gettypeinfo

(PHP 4, PHP 5, PHP 7, PHP 8)

odbc_gettypeinfo — Retrieves information about data types supported by the data source

Description

odbc_gettypeinfo(resource $odbc, int $data_type = 0): resource|false

Retrieves information about data types supported by the data source.

Parameters

odbc: 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.

add a note

User Contributed Notes 1 note

down

andrea dot galli at acotel dot com ¶

21 years ago


Example: display all data types 

<?php

     $Link_ID = odbc_connect("DSN", "user", "pass");
     $result = odbc_gettypeinfo($Link_ID);

     odbc_result_all($result);

?>

add a note