Table 2-8 provides examples of how the settings of the text configuration object strings are interpreted.
The parenthetical numbers in the Interpreted string column 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 maximum number of positions for a text document
is 4294967295.
The interpretations in this table are only for CONTAINS queries. When data is parsed, AND, NOT, and NEAR are considered regular tokens; and 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)"' |
