Oracle DB – special characters in contains function

i have a BLOB field which stores some document contents.

And my Java program want to do a searching on that field ,

here is my SQL statement :

Select * from table_A where CONTAINS(BLOB_FIELD,'{Keyword}') > 0;

When user input ‘P-‘ and ‘P=’ , they got the some result.
I want to resolve the problem , thank you!!!

Source: oracle

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.