ODBC Driver for SQLite

Supported Data Types - ODBC Driver for SQLite

Data Type Mapping

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

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