Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Context Cartridge:Searching Reserved Words using Escape method not work.
Hi,all:
i am a beginner of the context cartridge,i want to search the reserved
character,there are introduce that using escape method to do it,but it
not work in my machine.
i have create an context index and this is the indexed data is stored in PTECHDESCRIPTION,here is the PTECHDESCRIPTION field's context: Main Catalog Main Category 22222 22222 testforescapekeyword: AT&T (-)
this is the test result i have get:
this query can work:
select ... from ... where ... contains(PTECHDESCRIPTION,'{AT&T}',1)>0
and query of here not work:
select ... from ... where ... contains(PTECHDESCRIPTION,'{(-)}',1)>0
query of this not work:
select ... from ... where ... contains(PTECHDESCRIPTION,'{&}',1)>0
it seems the reserved words cannot search correctly and i want to search the reserved words.
can anyone tell me what's the reason and how to make the second query works?
thanks.
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Oct 19 2000 - 20:33:47 CDT
![]() |
![]() |