Hibernation criteria Case-insensitive question

Question

I have some problems with criteria like the following. It works fine, but I need the Subqueries.in condition to be case insensitive.

DetachedCriteria criteria = DetachedCriteria.forClass(Row.class, "row")
        .createAlias("subRows", "s_row").createAlias("s_row.fields", "field");

fields = DetachedCriteria.forClass(SubRowField.class, "field").add(
Property.forName("field.subRow.id").eqProperty(
"s_row.id")).add(Restrictions.eq("field.fieldName", "somename"));

criteria.add(Subqueries.in("somevalue", fields.setProjection(Projections.property("field.value"))))

Perhaps there is another way to achieve this result?

If any of you have an idea, that would be great.

Thanks in advance.

L0ck3

PS: I can provide the structure of the data model, if necessary, but I think that there should be enough code.

Answer 1

Is it possible to run it through a filter or a preprocessor that normalizes this case?