CosmosDB accent (diacritics) insensitive query

Question

Hello, I've searched everywhere but did not found the anwser I was looking for.
How do I query CosmosDB ignoring accents?
Example:
{"id": "1", "name": "Émpresa 1" }
{"id": "2", "name": "empresa 2" }

SELECT * FROM container_name WHERE name LIKE 'empresa%'

I want to retrieve both records from this query, how can I do that?
If it's not possible "out of the box" then is there any workaround?

Answer 1

Hi @Guilherme Molin ,

One way to do it is through the like operator by removing the diacritics character as mentioned in the below thread on Stack:

SELECT * FROM c WHERE c.name LIKE "%mpresa%"  

CosmosDB accent (diacritics) insensitive query

Same article talks about using Azure Cognitive Search which can also be used.

Please let us know if this helps.

----------

Please don't forgot to click on accept it as answer button wherever the information provided helps you. This can be beneficial to other community members as well.