Thread: Case-sentiveness on pgsql

Case-sentiveness on pgsql

From
Fernando Lozano
Date:
Hi there!

Now that the accents problem is solved I have another question regarding
Java and PostgreSQL (maybe just Postgres):

How to make the database permform SORT and LIKE canse-insensitive,
without having to use non-standard or not-guaranteed SQL constructs?
Ideally, treating characters like á, ã, A, á, Ã and a as equivalents.


[]s, Fernando Lozano