Firebase Realtime Database accept queries with strings in case sensitive manner.
Does this still apply for Firestore?
Asked
Active
Viewed 6,234 times
1 Answers
19
Yes, queries are still case sensitive.
To support case-insensitive or any other canonicalization you'll need to write a separate field that contains the canonicalized version and query against that. For example
db.collection("users").where("name", "==", "Dan")
db.collection("users").where("name_lowercase", "==", "dan")
Also see my longer answer here: Cloud Firestore Case Insensitive Sorting Using Query
mesqueeb
- 4,226
- 4
- 33
- 68
Dan McGrath
- 39,648
- 10
- 95
- 126
-
3any solution for this? – Nouman Ch Feb 06 '18 at 15:34
-
13That is very bad still in 2019 :/ – Joseph Briggs Dec 08 '19 at 19:35
-
5Can't believe this is still an issue :/ – Chris May 28 '20 at 02:12
-
8Same issue in 2021 – Aman Sharma Mar 31 '21 at 14:01
-
1OMG, when will it be available to add support of query with or without case sensitivity in Firestore API? – Cody Ng Sep 12 '21 at 02:47
-
Guys, still in after pandemic 2022 – Bala Apr 27 '22 at 07:37