Hello all,
I would like to get some help sorting a string field that has special characters.
I would like to get some expert suggestions on using collation that can solve a combination of special characters and case-insensitive string sorts.
I have pasted the code below has some definitions of collation we tried but failed to sort the combination that I mentioned earlier.
var events = await _collection.Find(filters, new FindOptions() { Collation = new Collation("en", strength: CollationStrength.Identical, numericOrdering: true) })
I appreciate any help in this concern. Thanks.