We wish to add case insensititvity to some of our collections, which we distribute through Mongo Realm’s GraphQL integration. Hence we have been looking on collations. From what we can understand, you can add collations to existing, populated collections, but then you’ll have to specify the collation in each query you perform (https://docs.mongodb.com/manual/core/index-case-insensitive/#create-a-case-insensitive-index).
On the other hand, you are able to setup a collation which will be inherited in all documents, when you set up your new collection (https://docs.mongodb.com/manual/core/index-case-insensitive/#case-insensitive-indexes-on-collections-with-a-default-collation).
Is there any way for us to specify a collation for a collection in our Realm rules for the given collection? If not, is it possible to somehow add some sort of collation rule that is inherited by all existing documents in the collection, so we don’t have to specify the collation in each database query?
Thanks in advance!