Firebase Realtime Database accept queries with strings in case sensitive manner.
Does this still apply for Firestore?
Asked
Active
Viewed 7,271 times
1 Answers
21
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
- 5,277
- 5
- 44
- 77
Dan McGrath
- 41,220
- 11
- 99
- 130
-
4any solution for this? – Nouman Ch Feb 06 '18 at 15:34
-
17That is very bad still in 2019 :/ – Rip3rs Dec 08 '19 at 19:35
-
7Can't believe this is still an issue :/ – Christopher May 28 '20 at 02:12
-
9Same issue in 2021 – Aman Sharma Mar 31 '21 at 14:01
-
3OMG, 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
-
1Guys, still in after pandemic 2022 – Bala Apr 27 '22 at 07:37
-
1So this is still a thing? I cannot order alphabetically regardless of case? – Dennis Ashford Jun 23 '22 at 14:31
-
Is this still not solved? – Daniel C Dec 04 '22 at 19:31
-
damn so simple yet firebase can't fix it – Marc Quebrar Tan Jan 19 '23 at 06:16
-
Whoever wrote Firebase firestore, sucks.. and don't get me started on realtime database. – Juhil Kamothi Apr 10 '23 at 15:13