I'm trying to use the JPA EntityManager find () method. My primary key is a string that matches the user's name.
I am using JPA / Hibernate / MYSQL.
My problem is that user 'David' matches is a search for 'David' reason, I believe that case insensitive string matching in underlying MYSQL makes me a whole heap of problems!
Has anyone found a great solution of this? I can make an original SQL call and use the recorded Binary Operator here:
Has anyone got a better solution? Ta
You have to set one of the tables or the entire database which is case-sensitive.
View: and
Comments
Post a Comment