0 Replies Latest reply on Jan 8, 2008 8:09 AM by CUGAT Chloe


    CUGAT Chloe Newbie

      I use jboss-4.0.5.GA and jboss-seam-1.2.1.GA.

      I want to do a search of member in my website.
      I want to compare input parameters with the members name (in the database) without any accent in order to have more results in this query.

      To sum up, I want to search for string in EJB-QL, but without a perfect match on characters with accent. I want a "é"(acute accent or grave accent) to be searched as a "e".

      I found in O'Reilly documentation only these functions (to format string) :
      - LOWER(String);
      - UPPER(String);
      - TRIM([[LEADING | TRAILING | BOTH] [trim_char] FROM] String);
      - CONCAT(String1, String2);
      - LENGTH(String);
      - LOCATE(String1, String2 [, start]);
      - SUBSTRING(String1, start, length).

      Is there a function which remove accent or replace it in EJB-QL ?

      Thank you !