Hibernate version: 3.0.3

Hi all,

Is there case sensitive comparsion in HQL ? eg.:

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 result was good.

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

Thx: Beci

your query do what you want

Sorry I'dont understand it :( I try a lot of different mode but the comparsion never was case sensitive, but only in Hibernate 2 where can I use "binary" keyword before string comparsion :((( In H3 I can't do it :(

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

do case sensitive comparison (return exactly 'Any WoRdS' )

If you want case insensitive try

FROM Foo as a WHERE upper(a.property)=upper('Any WoRdS')
(if your dialect support upper function)

Have you tried ? If it doesn't work you have problem with database (what is sql query then)
regards

I use "mysql 4.0.24-standard (on Debian)" with "mysql-connector-java-3.0.14-production-bin.jar" lib.

I try again and I hope it will be sucessfull:)

Do you say the HQL comparsion is case sensitive on basic?

Sorry thx your previous answer :)

yes - see generated sql

I saw the generated code see below:

select keresletel0_.meghatarozas as col_0_0_ from keresletElhelyezkedes keresletel0_ where keresletel0_.meghatarozas=?

?='AnY WoRd'

And the comparsion is not case sensitive (not only in java) :( because there isn't the "binary" keyword for the case sensitivity for mysql.

I don't know what is the solution in HQL for this :(


10^6 Thx :)

this sql have to return only column/columns with value = exactly 'AnY WoRd'
If you get another your sql server (mysql or what) isn't good and it is case sensitive

If you want case insensitive results use (I misunderstand, maybe)

from table a where upper(a.property) = upper(?)

Please see this: http://mysqld.active-venture.com/Case_S ... ators.html

And especially this address: http://dev.mysql.com/doc/mysql/en/case-sensitivity.html

So I think the problem is with mysql version :( or table column properties.

Bye

I don't know mysql , but it is correct sql for your need - your problem is mysql

Hello,

I found the solution finally (I hope :) )

I define the varchar column in the table with binary keyword :) and everything is allright

Thank you very much your help