odbc_field_type
(PHP 4, PHP 5)
odbc_field_type — Datatype of a field
Description
string odbc_field_type
( resource
$result_id
, int $field_number
)Gets the SQL type of the field referenced by number in the given result identifier.
Parameters
-
result_id -
The result identifier.
-
field_number -
The field number. Field numbering starts at 1.
Return Values
Returns the field type as a string, or FALSE on error.
- PHP Руководство
- Функции по категориям
- Индекс функций
- Справочник функций
- Расширения для работы с базами данных
- Уровни абстракции
- ODBC (Unified)
- odbc_autocommit
- odbc_binmode
- odbc_close_all
- odbc_close
- odbc_columnprivileges
- odbc_columns
- odbc_commit
- odbc_connect
- odbc_cursor
- odbc_data_source
- odbc_do
- odbc_error
- odbc_errormsg
- odbc_exec
- odbc_execute
- odbc_fetch_array
- odbc_fetch_into
- odbc_fetch_object
- odbc_fetch_row
- odbc_field_len
- odbc_field_name
- odbc_field_num
- odbc_field_precision
- odbc_field_scale
- odbc_field_type
- odbc_foreignkeys
- odbc_free_result
- odbc_gettypeinfo
- odbc_longreadlen
- odbc_next_result
- odbc_num_fields
- odbc_num_rows
- odbc_pconnect
- odbc_prepare
- odbc_primarykeys
- odbc_procedurecolumns
- odbc_procedures
- odbc_result_all
- odbc_result
- odbc_rollback
- odbc_setoption
- odbc_specialcolumns
- odbc_statistics
- odbc_tableprivileges
- odbc_tables
Коментарии
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.
Some fields can be of the following type too : REALHere 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
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 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...