MDAC 2.5 SDK - Visual FoxPro ODBC Driver
Support: Full
ODBC API Conformance: Level 1
Returns information about the data types supported by a data source. The driver returns the information in an SQL result set. The following table lists ODBC data types and the corresponding Visual FoxPro data type.
ODBC type | Visual FoxPro type |
SQL_BIGINT | Not supported. There is no 64-bit Visual FoxPro type. |
SQL_BIT | Logical |
SQL_CHAR | Character |
SQL_DATE | Date |
SQL_DECIMAL | Numeric |
SQL_DOUBLE | Double |
SQL_FLOAT | Double |
SQL_INTEGER | Integer |
SQL_LONGVARBINARY | Memo (Binary) |
SQL_LONGVARCHAR | Memo |
SQL_NUMERIC | Numeric*, Currency, Float |
SQL_REAL | Double |
SQL_SMALLINT | Integer |
SQL_TIME | Not supported. There is no Visual FoxPro time type. |
SQL_TIMESTAMP | DateTime |
SQL_TINYINT | Integer |
SQL_VARBINARY | Memo (Binary)*, General |
SQL_VARCHAR | Character |
*Default type
For more information on Visual FoxPro data types, see CREATE TABLE. For more information about this function, see SQLGetTypeInfo in the ODBC Programmer's Reference.