|
Supported Data Types - ODBC Driver for xBase |
|
|
|
Supported Data Types - ODBC Driver for xBase |
|
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 |