MDAC 2.5 SDK - Visual FoxPro ODBC Driver


 

SQLGetTypeInfo

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.