Case sensitivity in HQL

becike · **Joined:** Wed May 04, 2005 5:38 pm **Posts:** 15

Hibernate version: 3.0.3

Hello,

Please help :) How can I use case sensitivity in HQL. The "binary" keyword drops exception, moreover "=" and "like" aren't case-sensitive.

:(

Thx: Beci

emmanuel · **Posted:** Fri May 13, 2005 4:53 am

as per the doc, HQL keywords are not case sensitive

becike · **Joined:** Wed May 04, 2005 5:38 pm **Posts:** 15

I think not keywords but comparsion see the example below:

FROM Foo as a WHERE a.property='Any WoRdS'

(I can use "binary" keywords in Hibernate 2 - in HQL - that was right for me, when I use that the case sensitivity was good)

and the comparsion only will be true if the property's String exatly equals to 'Any WoRdS'.
Is it possible?

Thx: Beci

jemiller · **Posted:** Sat May 14, 2005 4:56 pm

I think that would be dependent on how you have the database setup, as to whether or not comparisons of strings are case sensitive.