sa_nchar_terms System Procedure

Breaks an NCHAR string into terms and returns each term as a row along with its position.

Syntax

sa_nchar_terms( 'char-string' [ , 'text-config-name' [, 'owner' ] ] ] 	)

Parameters

char-string – the NCHAR string you are parsing.

text-config-name – the text configuration object to apply when processing the string. The default value is 'default_nchar'.

owner – the owner of the specified text configuration object. The default value is DBA.

Description

You can use sa_nchar_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.

The syntax for sa_nchar_terms is similar to the syntax for the sa_char_terms system procedure.

Note: The NCHAR data type is supported only for IN SYSTEM tables.

Permissions

None.