Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> intermedia text search string with special charachters at beginning / end bounces with error

intermedia text search string with special charachters at beginning / end bounces with error

From: Stefan Lipp <snlipp_at_hotmail.com>
Date: 23 Apr 2003 08:44:14 -0700
Message-ID: <a8e740ef.0304230744.4e4915e6@posting.google.com>


Hello!

I discovered a strange behaviour in Oracle Intermedia (8.1.6 / Solaris):

Consider a query with:
contains (t.body, '(München) OR (M&uuml;nchen)', 1) > 0
--> query went through with results, no problems!

But a query with:
contains (t.body, '(Überschrift) OR (&Uuml;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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US