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.