persistence@glassfish.java.net

case insensitive

From: TianMing Pan <Tpan_at_agilitylogistics.com>
Date: Mon, 14 Jan 2008 14:15:41 +0300

Hi,
      When I use the JPA, I am confuse about its query for how to make
it case insensitive.
For exampe, if I search in the db as "c.name like ?1" and setParameter 1
as "china", then
the result will not include the "China". So could you tell me how to
make the query case
insensitive? Thanks a lot.

Rds


All Business is handled subject to our General Trading Conditions. A copy can be made available upon request.