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 Atlas, go to the Data Explorer page for your project.
If it's not already displayed, select the organization that contains your project from the Organizations menu in the navigation bar.
If it's not already displayed, select your project from the Projects menu in the navigation bar.
In the sidebar, click Data Explorer under the Database heading.
The Data Explorer displays.
Note
You can also go to the Clusters page, and click Data Explorer under the Shortcuts heading.
Set the collation.
Select the collection.
In the Query Bar, click Options.
Enter the
localefield in the collation document to specify the ICU Locale code for the desired language in the Collation field.Example
To use the
pinyinvariant 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.