uselike
For Unicode fields, use the Oracle LIKE operator instead of the
LIKEC operator in the where clause of queries
USYS$ORA_PARAMS = uselike
Use
Use uselike only if you encounter performance problems when working with
Unicode data and the database is set up with Unicode character sets (UTF8, UTF16, and so on),
because LIKE calculates strings using characters as defined by the input character
set.
Description
By default, the connector invokes the Oracle LIKEC operator when the
where clause is used in SQL queries with Unicode data
($DEF_CHARSET=UTF8 or when the field has a W
interface). In some configurations, this may lead to performance problems.
