-
Type: Task
-
Resolution: Fixed
-
Priority: Critical - P2
-
Affects Version/s: None
-
Labels:
-
-
3
Dear all,
Our documentation is proving inconsistent/contradictory information regarding `$regex` operator and case-insensitive indexes:
One: Case insensitive regular expression queries generally cannot use indexes effectively. The $regex implementation is not collation-aware and is unable to utilize case-insensitive indexes.
Two: If you frequently run case-insensitive regex queries (utilizing the i option), .....Alternatively, you can create a case-insensitive index to support your queries.* You can also specify a collation on an index to define language-specific rules for string comparison, such as rules for lettercase and accent marks.
Thank you in advance for taking time and fixing this.
Friendly regards,
Marina.