java - Oracle DB - special characters in contains function -

i have blob field stores document contents.

and java program want searching on field ,

here sql statement :

select * table_a contains(blob_field,'{keyword}') > 0; 

when user input 'p-' , 'p=' , got result. want resolve problem , thank you!!!

contains uses number of characters/words have escaped if want search actual character (-,=,*,%,etc). try 'p\-' , see if helps... if not see below.

also odds pretty high lexer setting determining period after p determines word break (end of sentence). controlled dba , has complex logic determine how words split/not split text searching.