I have installed the current development version 3.3.11 in order to test the case insensitive index that is apparently supported according to https://jira.mongodb.org/browse/SERVER-90. I have tried this from a mongo shell and a simple test database and it does seem to work.
Unfortunately, even though one specifies collation (and strength) during index creation, one must also specify the same collation params with .find
in order to get case insensitive matches. If collation is omitted from the query, index behaves in a case sensitive fashion.
Even the newest C# MongoDB driver (2.3.0-beta1) does not seem to support supplying collation params to a query. So even though I have upgraded the engine and database, C# driver, created the index with required collation, I cannot seem to get the results using the current driver.
Is there a "manual" way of supplying extra arguments to a query?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…