views:

19

answers:

0

Hi there,

i want a working example for using oracle built in 'utl_match.jaro_winkler_similarity' method which compare two strings based on how much they are matched, i want the example such that it restrict the results of criteria to only which value of (X) match with given text, i tried some kind of statements but it seem to be not working properly, like 'utl_match.jaro_winkler_similarity(%s,'new') > 55', and then passing this sql query to 'CustomRestriction.sqlRestriction' as first attribute and the property name 'status' as second attribute, also is it supporting utf-8 encoding,

Regards,