Set Language Specific Rules for String Comparison
Use the Collation query bar option to specify language-specific rules for string comparison, such as rules for lettercase and accent marks.
Important
Feature unavailable in Flex Clusters and Serverless Instances
Flex clusters and Serverless instances don't support this feature at this time. To learn more, see Atlas Flex Limitations and Serverless Instance Limitations.
Set Collation
In the Query Bar, click Options.
Enter the
locale
field in the collation document to specify the ICU Locale code for the desired language in the Collation field.Example
To use the
pinyin
variant of the Chinese collation, use the following collation document:{ "locale" : "zh@collation=pinyin" } As you type, the Find button is disabled and the Collation label turns red until a valid query is entered.
Click Find to run the query and view the updated results.
Clear the Query
To clear the query bar and the results of the query, click Reset.
To Learn More
See the supported languages and locales section in the MongoDB Manual.
See the possible fields in a collation document in the MongoDB Manual.