ODBC Driver for SQLite

Supported Data Types

ODBC Driver for SQLite supports all the SQLite data types.

The complete list of SQLite data types is available in the SQLite documentation.

Data Type Mapping

The following table describes how ODBC data types are mapped to SQLite 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

© 2015-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback