I'm running a query like the one below on my JBoss 4.0.3 (EJB3), and it successfully returns a DB row with name "a" for both when pname = "a" and when pname is "A" (i.e. it is case-insensitive). It is also returning the same for when pname is "a " (i.e. with trailing spaces). Any help?
em.createQuery("from Item item where item.name = :name). setParameter ("name", pname).
JBoss 4.0.3 against MySQL 4.1.11 (3.2.0-alpha connector)