persistence@glassfish.java.net

insensitive search

From: Laurent Yhuel <laurent.yhuel_at_apologic.fr>
Date: Wed, 19 Sep 2007 13:54:18 +0200

Hi

 

I have to search in a column with case insensitive and without accent.

Exemple

DépAssŕ => depassa

 

Does it possible with named query?

 

I view the function LOWER in named query but it’s not enough for me.

 

Laurent