Skip to content
Back

Search case insensitive

  • 0
  • Databases
apperside
9 Sep, 2025, 08:27

Hi, I am trying to perform a full text search on a field, but everything seem to be working case sensitive. Both Query.contains and Query.search only work case sensitive and in the docs I cannot find anything related to this. The only solution I can think of is to create a clone of the column where I save everything lowercase and perform the search on that, but I don't like it too much..

TL;DR
Developers are having trouble performing a case-insensitive full text search using Query.contains and Query.search. They are considering creating a clone column with lowercase data for the search.
Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more