JPQL sorting (ORDER BY) results - case insensitive
I have the following code that creates a Query Object and gives me an order for my results:
EntityManager em = getEntityManager();
try{
Query q = em.createQuery("SELECT t FROM table_name t ORDER BY t.fieldName");
which works, except I'd like my sorted results to be case insensitive...
you know, in the order:
a
A
b
c
C
d
e
E
not
a
b
c
d
e
A
C
E
but I'm really at a loss how to perform this using JPQL in my TopLink application.
any ideas??
Thanks!
-Russ