Hibernate version:
2.1.6

Name and version of the database you are using:
MySQL 4.0.18


Hi,
I would like to confirm if it is true that for my particular configuration the query is case insensitive - though what I have read so far seems that query should be case sensitive.

I am using Spring framework together with Hibernate, here is the code:

...
private static final String countUserQuery = "select count(*) from User u where u.username=?";

...
int count = ((Integer) getHibernateTemplate().find(countUserQuery, user.getUsername()).iterator().next()).intValue();

In the database, I have a user with name 'Alex'. When I set user name to 'alex', it always return 1.

What's wrong here ? I thought query should be case InSensitive ....

thanks for your help,
li xin

for mysql, all sql queries are case insensitive, as far as i know - read the mysql manual

thanks !

checked and I can use something like:

from User user where binary user.name = ?

for case sensitive query.