0 Replies Latest reply on Jul 5, 2005 7:46 PM by Luiz-Otavio Zorzella

    Why is my EJB 3 query case-insensitive?

    Luiz-Otavio Zorzella Newbie

      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)

      Thanks,

      Zorzella