• 首页
  • vue
  • TypeScript
  • JavaScript
  • scss
  • css3
  • html5
  • php
  • MySQL
  • redis
  • jQuery
  • odbc_field_type()

    (PHP 4, PHP 5, PHP 7)

    Datatype of a field

    说明

    odbc_field_type(resource $result_id,int $field_number): string

    Gets the SQL type of the field referenced by number in the given result identifier.

    参数

    $result_id

    The result identifier.

    $field_number

    The field number. Field numbering starts at 1.

    返回值

    Returns the field type as a string, or FALSE on error.

    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.
    Some fields can be of the following type too : REAL
    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