escape characters in oracle functions
From: Sam Herman <samh_at_bhphoto.com>
Date: 10 Sep 2001 14:14:13 -0700
Message-ID: <688264e8.0109101314.676bc8f3_at_posting.google.com>
Date: 10 Sep 2001 14:14:13 -0700
Message-ID: <688264e8.0109101314.676bc8f3_at_posting.google.com>
I'm working to improve the search functionality on my company's web site one of the problems is that I bumped in to is that I cant figure out what character escapes special character's in the oracle functions for example.
I’m using the contains function like this CONTAINS (columnname,'$A/P%',5) and I get the following error executing ODCIIndexStart() routine
ORA-20000: interMedia Text error: DRG-50937: query too complex DRG-51030: wildcard query expansion resulted in too many terms
the problem is that the oracle treats the slash as a special character
that divides the word into two so the wildcard % runs on P only, and
that’s a problem,
because the search criteria is very broad, and that's why it gives me
an error
now the question is how do I escape the / character Received on Mon Sep 10 2001 - 23:14:13 CEST