This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(115.19999999999999, 4%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%3C/text%3E%3C/svg%3E)
Hi - I'm trying to migrate from a self-hosted mongodb instance to cosmos db.
I managed to move all collections (after raising the limits several times).
Now my work is to build all missing indices. Unfortunately I can't find a way to set the collation on an index. My target is to be able to sort on german text. So I attempt to define an index in mongosh like:
db.Users.createIndex({lastName:1},{collation:{locale: "de"}})
but I receive:
MongoServerError: collation
An Azure NoSQL database service for app development.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Hi Munkel, Georg •,
Welcome to Microsoft Q&A forum and thanks for using Azure Services.
As I understand, you want to know if there is a way to set collation on an index in Azure Cosmos DB Mongo API.
I am checking on this ask internally and will let you know.
Thanks.
Hi Munkel, Georg •,
Following up to see if the below suggestion was helpful. If this answers your query, do click Accept Answer and Mark Helpful for the same. And, if you have any further query do let us know.
Hi Munkel, Georg •,
As mentioned by the Internal team, Collation is not supported currently with Cosmos DB for MongoDB with both RU and vCore based.
However, I would recommend you to share your valuable feedback for this feature enablement over Azure Cosmos Database Feedback Channel where concerned team will look into the requests and prioritize on the basis of importance and up-votes.
Thank you.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 81%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Is it available now or still not available?
is it still not available in version 7.0
Collation is not supported currently with Cosmos DB for MongoDB with both RU and vCore based.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(12.8, 12%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELG%3C/text%3E%3C/svg%3E)
It's not supported upon index creation or not supported at all?
Is there any mechanism to control the behaviour upon String sorting?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 81%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKF%3C/text%3E%3C/svg%3E)
Hi, seems on Cosmos with Mongo server 7.0 I still cannot sort using Collations.
Is there any news when this will be available? Need to sort in a case-insensitive way