From: Romanowski, Tim <tim.romanowski_at_lmco.com>
Date: Thu, 05 Apr 2007 18:18:33 -0400

I noticed that when issued an ORDER BY clause as part of a query, it uses
the binary value instead of an ASCII or linguistic value. Is there a way
with JPA to force a case insensitive sort on the query? NLS_SORT?

 

"select object(o) from MyEntity as o ORDER BY o.anyParticularField"

 

 

Tim