odbc_field_scale
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.
odbc_field_type
(PHP 4, PHP 5)
odbc_field_type — Tipo di dato di campo
Descrizione
string odbc_field_type
( resource
$id_risultato
, int $numero_campo
)La funzione odbc_field_type() restituisce il tipo di dato SQL del campo indicato dal numero all'interno di un set di righe referenziate dall'identificativo di risultato ODBC passato. La numerazione delle colonne parte da 1.
add a note
User Contributed Notes
odbc_field_type - [4 notes]
jschwartz at the-infoshop dot com ¶
3 years ago
jorge dot emailNOSPAM at gmail dot com ¶
6 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
jazper at lycos dot de ¶
10 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.