Case in-sensitivity in query search

RLOMASKY

Hi,

When someone types into the query filter box, the search is case insensitive. Is that possible? I'm using Postgres, if that makes a difference.

Thanks,
Rachel

Jaymer

sure, thats possible.
its insensitive on my MS SQL also.

RLOMASKY

How? In AwareIM? Or I change something in the database?

Jaymer

google:

postgres case-insensitive collation

so much depends on your version & platform.
https://www.postgresql.org/docs/9.5/static/citext.html

actually, the wording on your initial post is a little confusing.
I'm not sure if you were asking or telling in the 1st statement.
i'm not sure if you want case-insensitive search (and don't have it), or if what you are experiencing is case-insensitive search (and can't believe its true).