ODBC Driver for MongoDB

Supported Data Types - ODBC Driver for MongoDB

Data Type Mapping

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

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

MongoDB Data Types ODBC Data Types

INT64

SQL_BIGINT

INT32

SQL_INTEGER

STRING

SQL_WVARCHAR

DOUBLE

SQL_DOUBLE

BOOLEAN

SQL_TINYINT

DATETIME

SQL_TYPE_TIMESTAMP

OBJECTID

SQL_WVARCHAR

Complex data types

Fields of complex data types (OBJECT, ARRAY, REGULAR EXPRESSION, JAVA CODE, JAVA CODE WITH SCOPE, BINARY, NULL, UNDEFINED, MIN KEY, MAX KEY, TIMESTAMP) are mapped either as a single string field and their content is displayed in the Extended JSON format, or as a set of their child fields, depending of the Complex fields as string option value.

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