Menu
Simba Technologies
Simba Technologies

Simba MongoDB ODBC Driver with SQL Connector 2.3.0
Installation and Configuration Guide

Enable Mixed Type Filter

Key Name Default Value Required

EnableMixedTypeFilter

Selected (1)

No

Description

This option specifies whether the driver uses mixed type filtering, which allows a value to pass the filter even if it is not the same data type as the specified filter term.

  • Enabled (1): When filtering data, the driver retrieves all values that match the specified filter term, even if the values are stored as different data types than the filter term. For example, if the data store contains "1000" as a NumberInt value and also as a String value, when you execute a query that filters for "1000" as a String value, the driver returns both the NumberInt and String values.
  • Disabled (0): When filtering data, the driver only retrieves values that match the data type of the specified filter term. For example, if the data store contains "1000" as a NumberInt value and also as a String value, when you execute a query that filters for "1000" as a String value, the driver only returns the String value.

Note:

Mixed type filtering requires the driver to scan the entire MongoDB collection. You can disable this feature to increase the driver's performance, but note that doing so also alters the results of your queries.