|
|
DataNucleus Forum » List all forums » » Forum: Queries : JDOQL » » » Thread: Problem with queries on unicode fields in Oracle 10g » » » » Post: Re: Problem with queries on unicode fields in Oracle 10g |
Print at Mar 15, 2010 2:57:05 AM |
| Posted by andy at Sep 4, 2006 7:58:06 AM |
|
Re: Problem with queries on unicode fields in Oracle 10g Queries work correct on this table: LOOKUP_NAME VARCHAR2(240) but not with LOOKUP_NAME NVARCHAR(240) 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. May be better use ESCAPE statement only when it is necessary (when match text contains SQL specific wildcard characters (in my case '%' and '_')). You dont know what the parameter text is going to include when compiling it. ---------------------------------------- -Andy   |
|
Current timezone is GMT Mar 15, 2010 2:57:05 AM |