on 2007 Aug 29 5:56 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
66 | |
10 | |
10 | |
10 | |
10 | |
8 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.