(PHP 4, PHP 5, PHP 7, PHP 8)
odbc_field_type — Datentyp eines Feldes
Liefert den SQL-Datentypen des Feldes, das in der angegeben Ergebniskennung numerisch referenziert wird.
statementDie Ergebniskennung.
fieldDie Feldnummer. Die Nummerierung beginnt mit 1.
Gibt den Feldtyp als Zeichenkette zurück, oder false im Fehlerfall.
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.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.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...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