Devart ODBC Driver for SQLite supports all SQLite data types.
The following table describes the mapping between the SQLite and ODBC data types.
| SQLite data type | ODBC data type |
|---|---|
INT2 |
SQL_SMALLINT |
INT8 |
SQL_INTEGER |
INT64 |
SQL_BIGINT |
TINYINT |
SQL_TINYINT |
SMALLINT |
SQL_SMALLINT |
MEDIUMINT |
SQL_INTEGER |
BIGINT |
SQL_BIGINT |
UNSIGNED BIGINT |
SQL_BIGINT |
VARCHAR |
SQL_WVARCHAR |
CHAR |
SQL_WCHAR |
CLOB |
SQL_WLONGVARCHAR |
FLOAT |
SQL_FLOAT |
DOUBLE |
SQL_DOUBLE |
NUMERIC |
SQL_NUMERIC |
DECIMAL |
SQL_DECIMAL |
MONEY |
SQL_REAL |
NUMBER |
SQL_NUMERIC |
BOOL |
SQL_TINYINT |
BINARY |
SQL_BINARY |
VARBINARY |
SQL_VARBINARY |
DATE |
SQL_TYPE_DATE |
TIME |
SQL_TYPE_TIME |
TIMESTAMP |
SQL_TYPE_TIMESTAMP |