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