The Devart ODBC Driver for xBase supports all xBase data types.
The following table describes how the xBase data types are mapped to the ODBC data types.
xBase Data Types | ODBC Data Types |
---|---|
CHAR |
SQL_CHAR |
VARCHAR |
SQL_VARCHAR |
MEMO |
SQL_WVARCHAR |
INTEGER |
SQL_INTEGER |
BIGINT |
SQL_BIGINT |
DOUBLE |
SQL_DOUBLE |
FLOAT |
SQL_REAL |
NUMERIC |
SQL_NUMERIC |
LOGICAL |
SQL_BIT |
DATE |
SQL_TYPE_DATE |
TIME |
SQL_TYPE_TIME |
DATETIME |
SQL_TYPE_TIMESTAMP |
VARBINARY |
SQL_VARBINARY |
BLOB |
SQL_LONGVARBINARY |