Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PLEASE HELP: CONTAINS and special characters
"Martin Runkel" <mrunkel_at_gmx.net> wrote in message
news:a1vcig$fk1$07$1_at_news.t-online.com...
> Yes, as I said....
> "...I tried to escape by using '%{#}%' and '%\#%'..."
>
>
>
>
> "timkarnold" <timkarnold_at_home.com> wrote in message
> news:PnA08.71056$fo.26245604_at_news1.rdc1.md.home.com...
> >
> > "Martin Runkel" <mrunkel_at_gmx.net> wrote in message
> > news:a1pu7d$85t$00$1_at_news.t-online.com...
> > > As a result of a website fulltext search option my application creates
a
> > > query like
> > >
> > > SELECT * FROM myTable WHERE (CONTAINS(text, '%#') > 0);
> > >
> > > if a user enters # as query string. Then I get
> > >
> > > ORA-29902: error in executing
> > > ODCIIndexStart() routine
> > > ORA-20000: interMedia Text error:
> > > DRG-50937: query too complex
> > > DRG-51030: wildcard query expansion resulted in too many terms.
> > >
> > > Obviously, the special character # is the reason for the problem
because
> I
> > > don't have any problems with alpha-numeric characters. Other special
> > > characters produce this error, too.
> > > I tried to escape by using '%{#}%' and '%\#%' but still got the same
> > error.
> > > Do I really have to forbid special characters or is there another
> > solution?
> > >
> > >
> > >
> > > Thank you for your help,
> > >
> > > Martin
> > >
> > >
> >
> > Have you tried wrapping the special characters in curly braces? {}
> >
> > HTH,
> > Tim
> >
> >
>
>
I don't see any curly braces in any of your code.
Tim Received on Tue Jan 15 2002 - 07:06:14 CST