Print at Mar 16, 2010 5:20:05 PM

Posted by andy at Sep 4, 2006 11:36:32 AM
Re: Problem with queries on unicode fields in Oracle 10g
1. ESCAPE char same.
2. JDOQL same, but SQL should be other:
with ESCAPE '\' -- for VARCHAR field
with ESCAPE '\\' -- for NVARCHAR field

Some RDBMSs are just weird (if you have an earlier version of Oracle (8, or 9) it would be nice to know if this is the case there too). Raise a JIRA with testcase please.
----------------------------------------
-Andy smile