Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> intermedia text search string with special charachters at beginning / end bounces with error
Hello!
I discovered a strange behaviour in Oracle Intermedia (8.1.6 / Solaris):
Consider a query with:
contains (t.body, '(München) OR (München)', 1) > 0
--> query went through with results, no problems!
But a query with:
contains (t.body, '(Überschrift) OR (Überschrift)', 1) > 0
--> the same with a special character at the end of a query term,
query bounces back with:
ORA-29902: error in executing ODCIIndexStart() routine ORA-20000:
interMedia Text error: DRG-50901: text query parser syntax error
Is this a bug or feature?
I also dug through OTN and this newsgroup, but found nothing similar.
Help would be appreciated,
thx Stefan Received on Wed Apr 23 2003 - 10:44:14 CDT