Breaks a CHAR string into terms and returns
each term as a row along with its position.
Syntax
sa_char_terms( 'char-string' [, 'text-config-name' [, 'owner' ] ] ] )
Parameters
char-string – the CHAR string
you are parsing.
text-config-name – the text
configuration object to apply when processing the string. The default
value is 'default_char'.
owner – the owner of the specified
text configuration object. The default value is DBA.
Description
You can use sa_char_terms to
find out how a string is interpreted when the settings for a text
configuration object are applied. This can be helpful when you want
to know what terms would be dropped during indexing or from a query
string.
Example
Return the terms in the CHAR string 'the
quick brown fox jumped over the fence':
CALL sa_char_terms
( 'the quick brown fox jumped over the fence' );
CHAR string interpretationTerm
|
Position
|
the
|
1
|
quick
|
2
|
brown
|
3
|
fox
|
4
|
jumped
|
5
|
over
|
6
|
the
|
7
|
fence
|
8
|