This content has been marked as final.
Show 5 replies
-
1. Re: Case insensitive finder methods
fbiaggi Nov 6, 2003 9:28 AM (in response to finn)Hi,
you may set your search string to uppercase and search with the UCASE sql option.
Hope this helps.
ciao. -
2. Re: Case insensitive finder methods
finn Nov 6, 2003 9:35 AM (in response to finn)I should have mentioned that I use EJB query language for all the finders methods. I guess I cannot use the above solution then?
Thanks
Lars -
3. Re: Case insensitive finder methods
fbiaggi Nov 6, 2003 9:42 AM (in response to finn)within jaws it works:
UCASE(myfield) LIKE {0} -
4. Re: Case insensitive finder methods
adrian.brock Nov 6, 2003 5:37 PM (in response to finn)UCASE will perform a full table scan (check every row)
which does not scale to a large number of rows.
Better is to create a mirror field that has already been
converted to upper case when you write to the db.
You can then create an index over that field.
Regards,
Adrian -
5. Re: Case insensitive finder methods
u268 Nov 7, 2003 9:23 AM (in response to finn)There is a sample solution 4 your problem ;)
http://www.jboss.org/modules/bb/index.html?module=bb&op=viewtopic&t=