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.