Devart ODBC Driver for xBase supports all xBase data types.
The following table describes the mapping between the xBase and ODBC data types.
| xBase data type | ODBC data type |
|---|---|
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 |