How to use the LIKE_INSENSITIVE ?

[Former Member]

Hi all,

I've updated my DB2E 8.2.2 to 8.2.4 and applied the patch SP20DELTA for MI2.5.

My purpose is to use the LIKE_INSENSITIVE operator during the search function.

In the "SearchProcessImpl.java", I tried to replace the following line :

(...)
protexted RelationOperatorType defaultSearchOperator=RelationOperatorType.LIKE;
(...)

by

(...)
protexted RelationOperatorType defaultSearchOperator=RelationOperatorType.LIKE_INSENSITIVE;
(...)

But after testing the program, nothing changed (as before the upgrade).

Could you please help me to use LIKE_INSENSITIVE operator ?

Kind regards

[Former Member · Accepted solution]

LIKE is case-SENSITIVE

LIKE_INSENSITIVE is case-INSENSITIVE

wildcard symbol used is *

e.g.: searchstring "key" is not the same as "KeY"

sometimes the behavior of the underlying database differs...

SQL_LIKE

wildcard symbol used is %

e.g. searchstring "k%y"

regs

jo

[Former Member · Accepted solution]

That was the problem,

Thank you so much,

Kind regards,

Alex