ODBC Driver for NexusDB

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

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