Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Breaks an NCHAR string into terms and returns each term as a row along with its position.
sa_nchar_terms( 'text' [, 'config_name' [, 'owner' ] ]
The NCHAR string you are parsing.
The text configuration object to apply when processing the string. The default is 'default_nchar'.
The owner of the specified text configuration object. The default value is NULL, and the current user is assumed if the
owner is not specified or if NULL is specified.
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 NCHAR string, It's a work-at-home day!, using the default NCHAR text configuration
CALL sa_nchar_terms (N'It''s a work-at-home day!', 'default_nchar', 'sys');