Hello,
i am using oracle text to search etxt fields in the database.
Following phrase i want to find "TP-LINK TL-SG108 8-Port Gigabit Switch"
by searching "sg108"
This settings are made to create the text index:
filter: NULL_FILTER
section group: NULL_SECTION_GROUP
lexer: BASIC_LEXER
printjoins: -
mixed_case: NO
wordlist: BASIC_WORDLIST
stemmer: GERMAN
fuzzy_match: GERMAN
The select statement is this: select * from table where contains(indexfield,'sg108')>0
But this results in null value.
Only this statement results in the correct way
select * from table where contains(indexfield,'%sg108%')>0
I think the (minus) sign is the problem, because it is a reserved word for searching text. But how to find text phrases which have this sign ?
I am not searching for the minus sign, so i can not know, that is there ?
Regards
Frank