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