0 Replies Latest reply on Apr 14, 2005 2:47 AM by Yevgen Bushuyev

    LIKE and non-ASCII encoding

    Yevgen Bushuyev Newbie

      Hi.
      As far as i can see the only way to use LIKE construct with dynamic queries is to assemble pattern like in a string:

      String query = "SELECT OBJECT(x) AS x FROM Xxx WHERE x.name LIKE '"+pattern+"'";

      ...

      It works fine while searching in english text but fails to deal with non-ASCII encoding.

      I've attempted to make pattern an input parameter (Since ejb spec says, that The pattern_value is a string literal or a string-valued input parameter) but without any success - ?1 was treated as pattern...

      Thanx, eugen.