The Devart ODBC Driver for SQLite supports all SQLite data types.
The following table describes how the SQLite data types are mapped to the ODBC data types.
SQLite Data Types | ODBC Data Types |
---|---|
INT2, SMALLINT |
SQL_SMALLINT |
TINYINT |
SQL_TINYINT |
BIGINT |
SQL_BIGINT |
UNSIGNED BIGINT |
SQL_BIGINT |
INT8 |
|
INT64 |
|
MEDIUMINT |
SQL_INTEGER |
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 |