db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Michel Beijlevelt" <...@lucka.nl>
Subject setIgnoreCase() not working on Oracle?
Date Tue, 22 Jul 2003 11:48:47 GMT
Hi all,

I've noticed no effect at all when setting the setIgnoreCase() either on
Criteria or on a single Criterion.

I expected the generated SQL to look something like WHERE UPPER(col) LIKE
UPPER(sarg), but it doesn't. It generates the SQL without the UPPER() (or
LOWER() or whatever), but just plain, whether the IgnoreCase is set true
or false.

For the time being I wrote my own Criteria class that handles criteria
ignoring case.

Anyone else seen this?

Using Torque 3.0 on Oracle 8i.

gr. Michel

To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

View raw message