Supported Data Types - ODBC Driver for NexusDB

Data Type Mapping

The Devart ODBC Driver for NexusDB supports all NexusDB data types.

The following table describes how the NexusDB data types are mapped to the ODBC data types.

NexusDB Data Types	ODBC Data Types
CHARACTER CHAR NULLSTRING SHORTSTRING CHARACTER VARYING CHAR VARYING VARCHAR	SQL_VARCHAR
SINGLECHAR	SQL_CHAR
CHARACTER LARGE OBJECT CHAR LARGE OBJECT CLOB TEXT	SQL_LONGVARCHAR
NATIONAL CHARACTER NATIONAL CHAR NCHAR NATIONAL CHARACTER VARYING NATIONAL CHAR VARYING NCHAR VARYING NVARCHAR	SQL_WVARCHAR
NSINGLECHAR	SQL_WCHAR
NATIONAL CHARACTER LARGE OBJECT NCHAR LARGE OBJECT NCLOB	SQL_WLONGVARCHAR
BINARY LARGE OBJECT BLOB IMAGE	SQL_LONGVARBINARY
NUMERIC	SQL_NUMERIC
DECIMAL DEC MONEY	SQL_DECIMAL
BYTE TINYINT SHORTINT	SQL_TINYINT
SMALLINT WORD	SQL_SMALLINT
AUTOINC INTEGER INT DWORD RECREV	SQL_INTEGER
LARGEINT BIGINT	SQL_BIGINT
FLOAT	SQL_REAL
REAL DOUBLE PRECISION EXTENDED	SQL_DOUBLE
BOOLEAN BOOL	SQL_BIT
TIME	SQL_TYPE_TIME
TIMESTAMP DATETIME	SQL_TYPE_TIMESTAMP
GUID	SQL_GUID
BYTEARRAY	SQL_BINARY