|
Supported Data Types - ODBC Driver for MongoDB |
|
|
|
Supported Data Types - ODBC Driver for MongoDB |
|
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 |
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.