Re: PLEASE HELP: CONTAINS and special characters

"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 Received on Mon Jan 14 2002 - 06:43:27 CST