PHP: odbc_gettypeinfo - Manual

downloads | documentation | faq | getting help | mailing lists | reporting bugs | php.net sites | links | conferences | my php.net

search for in the

odbc_longreadlen odbc_free_result

Last updated: Fri, 26 Jan 2007

view this page in

# odbc_gettypeinfo

(PHP 4, PHP 5)

odbc_gettypeinfo -- Returns a result identifier containing 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. 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
odbc_gettypeinfo
andrea dot galli at acotel dot com
29-Apr-2003 09:45
`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
odbc_longreadlen odbc_free_result

Last updated: Fri, 26 Jan 2007
show source | credits | stats | sitemap | contact | advertising | mirror sites
Copyright © 2001-2007 The PHP Group
All rights reserved.
This mirror generously provided by: Yahoo! Inc.
Last updated: Sat Mar 10 10:36:09 2007 PST