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]

Re: Oracle and case-insensitive search

[Jakob Braeuchi]

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]

Re: Oracle and case-insensitive search

[Danilo Tommasina]

Hi,
you can just do something like this...
Criteria c = new Criteria();
c.addLike( "upper(yourField)", yourString.toUpperCase() );
cheers
Danilo
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]

Oracle and case-insensitive search

[Frank Renaers]

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