[hibernate-users] accent insensitive query.

[CARLOS MATE DE ANTA]

Hi.
I use hibernate and Oracle 10.
My source code for search :

Criteria criteria = session.createCriteria(tabla.getClass());
Example example = Example.create(tabla).ignoreCase();
criteria.add(example);
ScrollableResults cursor = criteria.scroll();

In my bd I have:

TABLE_COLUMN
até
ATE
ATÉ
ate

If i find by "ate" string I obtain ate and ATE  but I also want to obtain até and ATÉ

¿how can I do that?
In oracle using regexp_like and alter session set NLS_SORT I can  do that but  with hibernate i don't know.
Thanks

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-users/attachments/20080314/5c44d89d/attachment.html