#12 ✓resolved
Marcel Ruegenberg

Case-insensitivity in Postgres

Reported by Marcel Ruegenberg | October 20th, 2008 @ 07:13 AM

In PostgreSQL, the LIKE statement performs a case-sensitive search, while ILIKE performs a case-insensitive search. It is often (probably in the default case) desirable to perform a case-insensitive search.

Case-insensitivity should be the default case, i.e. searching with Postgres is performed using ILIKE instead of LIKE.
Additionally, there could be an option to make searching case-sensitive (which is possible in both Postgres (by going back to using LIKE) and MySQL (see http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html)).

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile ยป

Provides common named scopes and object based searching.

People watching this ticket