Docs Menu
Docs Home
/
MongoDB Compass
/

Specify Custom Collation For Your Pipeline

On this page

  • About this Task
  • Steps
  • Example
  • Learn More

Use custom collation to specify language-specific rules for string comparison, such as rules for letter case and accent marks, within your aggregation pipeline.

When entering a collation document, the locale field is mandatory. Default collation field values vary depending on which locale you specify. To learn more about supported languages and locales, see Collation Locales and Default Parameters.

1

In the top-right corner of the pipeline builder, click Options.

More Options
2

Next to the Collation field, enter your collation document.

After you enter your collation document, the aggregation pipeline builder considers the language-specific rules that you specified in your document.

The following sample collation document specifies French as the chosen locale and sorts uppercase letters before lowercase letters with the caseFirst field:

{
locale: "fr",
caseFirst: "upper"
}

Back

Count Results