Examples of how the settings of the text configuration object strings are interpreted for CONTAINS queries.
The parenthetical numbers in the Interpreted string column in the table "CONTAINS string interpretations" reflect the position information stored for each term. The numbers are for illustration purposes in the documentation. The actual stored terms do not include the parenthetical numbers.
The interpretations in this table are only for CONTAINS queries. When data is parsed, AND, NOT, and NEAR are considered regular tokens; symbols like *, I, and others are dropped as they are not alphanumeric.
Configuration settings |
String |
Interpreted string |
|---|---|---|
TERM BREAKER: GENERIC MINIMUM TERM LENGTH: 3 MAXIMUM TERM LENGTH: 20 |
'w*' |
'"w*(1)"' |
'we*' |
'"we*(1)"' |
|
'wea*' |
'"wea*(1)"' |
|
'we* -the' |
'"we*(1)" -"the(1)"' |
|
'for* | wonderl*' |
'"for*(1)" | "wonderl*(1)"' |
|
'wonderlandwonderlandwonderland*' |
'' |
|
'"tr* weather"' |
'"weather(1)"' |
|
'"tr* the weather"' |
'"the(1) weather(2)"' |
|
'"wonderlandwonderlandwonderland* wonderland"' |
'"wonderland(1)"' |
|
'"wonderlandwonderlandwonderland* weather"' |
'"weather(1)"' |
|
'"the_wonderlandwonderlandwonderland* weather"' |
'"the(1) weather(3)"' |
|
'the_wonderlandwonderlandwonderland* weather' |
'"the(1)" & "weather(1)"' |
|
'"light_a* the end" & tunnel' |
'"light(1) the(3) end(4)" & "tunnel(1)"' |
|
light_b* the end" & tunnel' |
'"light(1) the(3) end(4)" & "tunnel(1)"' |
|
'"light_at_b* end"' |
'"light(1) end(4)"' |
|
'and-te*' |
'"and(1) te*(2)"' |
|
'a_long_and_t* & journey' |
'"long(2) and(3) t*(4)" & "journey(1)"' |