Create a text configuration to specify how TEXT indexes dependant on the text configuration process handle terms within the data.
Creating a text configuration (Sybase Central)
Connect to the database as a user with DBA or RESOURCE authority.
In the left pane, right-click the Text Configurations Objects folder and select New > Text Configuration Object.
Type a name for the text configuration.
Select the owner of the text configuration.
Select the type of database collation for the text configuration. Click Next.
Text configurations with NCHAR collation
are not supported by Sybase IQ TEXT indexes.
Select the Generic term-breaker algorithm.
Sybase IQ text configurations do not support the N-gram
algorithm. See “Text configuration object settings”.
Enter the minimum and maximum term length.
If using a external term breaker library, select “Use an external term breaker” and specify the external term breaker function and library.
Specify the function and library in the form
function-name@library-file-name.
Click Next.
If using a external prefilter library, select “Use an external prefilter” and specify the external prefilter function and library.
Specify the function and library in the form
function-name@library-file-name.
Add any terms to ignore when building a TEXT index with this text configuration to the Stoplist. Separate terms with a space.
Terms in this list are also ignored in a query.
Click Next.
Type a comment describing the text configuration, and click Finish.
Creating a text configuration object (Interactive
SQL)
Connect to the database as a user with DBA or RESOURCE authority.
Execute a CREATE TEXT CONFIGURATION statement.
For example, to create a text configuration object called myTxtConfig using the default_char text configuration object as a template, enter:
CREATE TEXT CONFIGURATION myTxtConfig FROM default_char;
