Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - SQL Reference » System Objects » System procedures » Alphabetical list of system procedures


sa_nchar_terms system procedure

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

sa_nchar_terms( 'char-string' [, 'text-config-name' [, 'owner' ] ]  ]  
  • char-string   The NCHAR string you are parsing.

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

  • owner   The owner of the specified text configuration object. The default 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.



Side effects


See also

The syntax for this system procedure is similar to the sa_char_terms system procedure. See the Example section in sa_char_terms system procedure.