Re: Oracle and case-insensitive search

[Bernhard v. Fromberg]

Hi,

try Criteria.addLike("Upper('foo')", bar.toUpperCase());

I think it could work and remember you can create an
index on UPPER(foo) in Oracle as far as I know.

Ciao,
Bernhard

hi frank,

ojb simply uses an sql LIKE, there is no magic added. so it's the dbms that treats the LIKE cas sensitive or insensitive.

jakob

Frank Renaers schrieb:

Hi,

In Oracle a search on a string (Criteria.addLike) seems to be Case
Sensitive.

How do you guys solve this problem.

In MsSql and MySql a Criteria.addLike is not case sensitive !

Thanks,

Frank Renaers

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

--
Mit freundlichen Gru"ssen,
Bernhard Fromberg

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]