Breaks a CHAR string into terms and returns each term as a row along with its position.
sa_char_terms( 'char-string' [, 'text-config-name' [, 'owner' ] ] ] )
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.
You can use this system procedure 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.
The following statement returns 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' );
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|