Can I get case INsensitive results using Criteria interface?

sunil_chandurkar · **Joined:** Fri Jun 10, 2005 12:25 pm **Posts:** 6

Guys

I am using Criteria interface to query the database. But I am getting results based on ASCII comparison.
E.g. if database has abc, ABC, PQR, DDD, ccc.

I am getting
ABC
PQR
DDD
abc
ccc

whereas I want

ABC
abc
ccc
DDD
PQR

Using Criteria how can I get it? I know how to get it using Query interface but I want to get this using only Criteria interface.

Thanks
Sunil

emmanuel · **Posted:** Fri Jul 01, 2005 10:06 am

ilike

sunil_chandurkar · **Joined:** Fri Jun 10, 2005 12:25 pm **Posts:** 6

Hi Emmanuel
I didn't get you. "ilike"???

Rgds
Sunil

emmanuel · **Posted:** Wed Jul 06, 2005 3:55 pm

org.hibernate.criterion.IlikeExpression

johnamos · **Joined:** Tue Oct 12, 2004 10:32 pm **Posts:** 5

I don't understand how ilike addresses the original question. This poster is asking about ordering the results. ilike is case-insensitive, but it does not order the results.

I am looking for an answer to the original question, but I haven't found it in this forum. It would be great if org.hibernate.criterion.Order had methods like:

static Order asc(String propertyName, boolean caseInsensitive)

and

static Order desc(String propertyName, boolean caseInsensitive)

emmanuel · **Posted:** Wed Jul 13, 2005 2:08 am

My fault I've read too quickly.