ODBC Driver for MongoDB

Supported Data Types

ODBC Driver for MongoDB supports all the MongoDB data types.

Data Type Mapping

The following table describes how ODBC data types are mapped to MongoDB 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-2017 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback