How to create unique index in MongoDB that works for both upper and lower case?

Question

This is how I created unique index for my key

db.members.createIndex( { "name": 1 }, { unique: true } )

but it does accept "name" : "Alex" and "name" : "alex"

is there a way to provide case sensitive and make sure there is only one alex in this case? Thanks!

Despite someone copying from the duplicate answer it's actually `strength: 2` as generally the better option for common use. And in the documentation - [Create a Case Insensitive Index](https://docs.mongodb.com/manual/core/index-case-insensitive/#create-a-case-insensitive-index) — Neil Lunn, Jun 09 '18 at 12:00
yes, strength 1 will allow collation matching of characters in different accents. kiddo = kiddø — kiddorails, Jun 09 '18 at 12:10
I tested strength 2 and mongoDb won't accept Alex1 eventhough it is not the same as alex. Any thoughts? — KevinVuD, Jun 09 '18 at 12:12

score 2 · Accepted Answer · answered Jun 09 '18 at 11:58

2

If you're using mongodb which version >= 3.4, you can use collation option:

db.myColl.createIndex( { category: 1 }, { unique: true, collation: { strength: 1 } } )

answered Jun 09 '18 at 11:58

1 Answers1