It doesn't appear that there is an easy trick.
http://www.redhat.com/docs/manuals/database/RHDB-7.1-Manual/sql/functions-ma...
From the above link:
The keyword ILIKE can be used instead of LIKE to make the match case insensitive according to the active locale. This is not in the SQL standard; it is a PostgreSQL extension.
Regards, Norm
ps. I'm a little disappointed in the tone of the recent discussion on this topic.
Klaus Darilion wrote:
Norman Brandinger wrote:
In MySQL see:
http://dev.mysql.com/doc/refman/5.0/en/case-sensitivity.html
One solution would be to define the table or particular column in question with a case sensitive character set mapping, for example:
CHARACTER SET latin1 COLLATE latin1_bin
Hi Norman!
This way I can make MYsql case sensitive. Do you also know a trick to make postgresql case insensitive?
regards klaus