Hello everybody,

My query doesn't differentiate between words which contains accents.

select * from words where word = 'cipö'

The result contain word 'cipö' and 'cipó' too!

I tried the following query
select * from words where BINARY word = 'cipö'

It works perfectly but the Hibernate doesn't known this operator 'BINARY'
http://webcache.googleusercontent.com/search?q=cache:kQlGe7eFbPAJ:dev.mysql.com/doc/refman/5.0/en/charset-binary-op.html+MySql+select+where+binary&cd=1&hl=hu&ct=clnk&gl=hu

How can I resolve this problem?
how can I force the Hibernate comparison to byte by byte?

Thanks.

By my humble opinion here is the possible way to resolve this problem.
The following settings need to put into my.ini
[mysqld]
init_connect='SET collation_connection = utf8_hungarian_ci'
init_connect='SET NAMES utf8'
character-set-filesystem=utf8
character-set-server=utf8
collation-server=utf8_hungarian_ci
skip-character-set-client-handshake
After need to modify the collation of database:
ALTER DATABASE dict CHARACTER SET utf8 COLLATE utf8_hungarian_ci;
All content is need to exists in the selected character set,therefore I needed to convert it to desired character set, in this case utf8_hungarian_ci
ALTER TABLE words CONVERT TO CHARACTER SET utf8 COLLATE utf8_hungarian_ci;
Of course not need the BINARY option after WHERE keyword.