It doesn't appear that there is an easy trick. http://www.redhat.com/docs/manuals/database/RHDB-7.1-Manual/sql/functions-matching.html
>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 > > _______________________________________________ Users mailing list Users@openser.org http://openser.org/cgi-bin/mailman/listinfo/users