MYSQL case sensitive search (using hibernate) for utf8

Question

Hi every one, I have Login Table that have utf8 charset and utf8 collation when I want check user name and retrieve other information for this specific user name the hql query give me the same result with lowercase and uppercase. what should l do for my HQL query that work case sesitive I use Mysql 5 and java hibernarte

this is my query:

return queryManager.executeQueryUniqueResult("select b.login from BranchEntity b where b.userName = ?", username);

Answer 1

The easiest way is to change your column's definition to use case-insensitive collation like utf8_bin.

Details are here