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

Home -> Community -> Usenet -> c.d.o.misc -> Re: PLEASE HELP: CONTAINS and special characters

Re: PLEASE HELP: CONTAINS and special characters

From: timkarnold <timkarnold_at_home.com>
Date: Tue, 15 Jan 2002 13:06:14 GMT
Message-ID: <aPV08.73763$fo.27171154@news1.rdc1.md.home.com>

"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

Original text of this message

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