persistence@glassfish.java.net

Case Insensitive search

From: Laurent Yhuel <laurent.yhuel_at_apologic.fr>
Date: Wed, 19 Sep 2007 11:40:05 +0200

Hi

 

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

Exemple

Dépasse => depasse

 

Does it possible with named query?

 

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