Hi, thanks for your reply. Performing a find on a single field by specifying the collation (with or without an index) does not seem to perform a “containing” search. In your example, I would want to be able to search for “caf” and all 4 results should be found. Ideally, I would want to use an index as the data will get pretty big even after doing any additional initial match stages to reduce the data size.
A regex solution is an option, but I do not like the idea of the only option being to not use the index. It’s also not ideal to have to adjust my expressions to support different diacritic characters in this way.
It just feels like there should be a way to do a “contains” for your first option…