Print at Mar 15, 2010 6:41:00 PM

Posted by khomikh at Sep 4, 2006 11:01:00 AM
Re: Problem with queries on unicode fields in Oracle 10g

Which query works correct ? The same one you quoted below? i.e with the same ESCAPE char ? i.e what is the JDOQL and SQL that works on the first and not on the second.

1. ESCAPE char same.
2. JDOQL same, but SQL should be other:
with ESCAPE '\' -- for VARCHAR field
with ESCAPE '\\' -- for NVARCHAR field

Second query works when it's running manually from SQL-Plus.