My search function currently is case-sensitive. If users enter their searches not following the exact capitalizations on supabase, it doesnt return any results even if it exists. Is there a simple way to make the search case insensitive? Thanks!
Edit: Solved!
Steps to solve this:
1. Enable CITEXT extension on Supabase
2. Change datatype of column to citext through SQL editor:
alter table TableName
alter column "ColumnName"
type citext;