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 |