1 Reply Latest reply on Oct 5, 2006 1:48 PM by asack

    Case sensitive queries?

    asack

      It seems that queries using EJB3 are case insensitive, i.e if I do:

      em.find(class, PK) or em.find(class, pk) they are equivalent (database is MySQL).

      Is there anyway to add case sensitivity?

      Thanks!

        • 1. Re: Case sensitive queries?
          asack

           

          "asack" wrote:
          It seems that queries using EJB3 are case insensitive, i.e if I do:

          em.find(class, PK) or em.find(class, pk) they are equivalent (database is MySQL).

          Is there anyway to add case sensitivity?

          Thanks!


          Crap this maybe MySQL....damn it...nevermind...for some reason I thought this was an EJB3 hibernate thing since its making the table for me.

          Is there anyway to tell Hibernate to create the table with case sensitivty on?