Hello everyone,
Yes, I am having exactly the same problem. I used to use
MS SQL server 2000/2005 express. When I use JPA with these
DBMS, my queries would always return data whether the user enters
data in lower case or upper case, the result was never case sensitive.
I am now trying to use the JavaDB that comes with the Sun application server
9s. Data is now sensitive. I would be interested to know how I can make this
insensitive.
Thanking you.
eve
Date: Mon, 14 Jan 2008 14:15:41 +0300From: Tpan_at_agilitylogistics.comTo: persistence_at_glassfish.dev.java.netSubject: case insensitive
Hi, When I use the JPA, I am confuse about its query for how to makeit case insensitive.For exampe, if I search in the db as "c.name like ?1" and setParameter 1as "china", thenthe result will not include the "China". So could you tell me how tomake the query caseinsensitive? Thanks a lot.RdsAll Business is handled subject to our General Trading Conditions. A copy can be made available upon request.
_________________________________________________________________
Who's friends with who and co-starred in what?
http://www.searchgamesbox.com/celebrityseparation.shtml