PHPverse 2025

odbc_field_type

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

odbc_field_typeTipo de datos de un campo

Descripción

odbc_field_type(Odbc\Result $statement, int $field): string|false

Lee el tipo de datos SQL de un campo, identificado por su número.

Parámetros

statement

The ODBC result object.

field

El número del campo. La numeración comienza en 1.

Valores devueltos

Devuelve el tipo del campo, en forma de string, o false en caso de error.

Historial de cambios

Versión Descripción
8.4.0 statement expects an Odbc\Result instance now; previously, a resource was expected.
add a note

User Contributed Notes 5 notes

up
1
jschwartz at the-infoshop dot com
15 years ago
Quick note: as noted below, MS Access type AutoNumber comes across as type COUNTER. What I didn't see mentioned is that PHP interprets type COUNTER as a string, not an integer.

More annoying than anything else, in my particular case; but I'd guess it could bite somebody, somewhere.
up
1
jazper at lycos dot de
22 years ago
Returntypes on Access2000
COUNTER - Autoincrement
VARCHAR - Text
LONGCHAR - Memo
INTEGER - Number
DATETIME - Date/Time
CURRENCY - Currency
BIT - TRUE/FALSE
LONGBINARY - OLE-Object
LONGCHAR - Hyperlink

cheers, j.a.z.
up
0
ted at convey dot de
9 years ago
odbc_field_type seems to return the data type of the database backend, not the data types from ODBC documentation.

Example: With my Oracle backend I get data types like "CLOB" and "VARCHAR2" while ODBC only knows SQL_LONGVARCHAR for long character data...
up
0
jorge dot emailNOSPAM at gmail dot com
18 years ago
Here is the complete list!

Access 2003 as the following teturntypes:

COUNTER - Autoincrement
VARCHAR - Text
LONGCHAR - Memo
INTEGER - Number
DATETIME - Date/Time
CURRENCY - Currency
BIT - TRUE/FALSE
LONGBINARY - OLE-Object
LONGCHAR - Hyperlink
DOUBLE - Double Number
BYTE - Byte Number
up
0
not[at]wgpower[dot]net
19 years ago
Some fields can be of the following type too : REAL
To Top