Case-sentiveness on pgsql

Started by Fernando Lozanoabout 24 years ago1 messagesgeneral

fsl@centroin.com.br

about 24 years ago

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