Difference between revisions of "SET TSLENGTH"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
Text Searching | Text Searching | ||
| Line 15: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[INDEX]], [[KEY()]], [[LOWER()]], [[NDX()]], [[ | + | [[DB_TSINDEX]], [[INDEX]], [[KEY()]], [[LOWER()]], [[NDX()]], [[SET INDEX]], [[SET ORDER]], [[TSPOS()]], [[TSWORD()]], [[UPPER()]] |
| Line 29: | Line 26: | ||
==Example== | ==Example== | ||
| − | < | + | <code lang="recital"> |
set tslength to 15 | set tslength to 15 | ||
use example | use example | ||
| − | index on tsword(first_name,1) to shortname</ | + | index on tsword(first_name,1) to shortname |
| + | </code> | ||
Revision as of 13:19, 20 April 2009
Class
Text Searching
Purpose
Specify size of Text Search Index key
Syntax
SET TSLENGTH TO <expN>
See Also
DB_TSINDEX, INDEX, KEY(), LOWER(), NDX(), SET INDEX, SET ORDER, TSPOS(), TSWORD(), UPPER()
Description
The SET TSLENGTH set command determines the size of Text Search Index keys. The default is 32 characters. The value to set is specified in <expN>. Smaller keys may result in inaccurate searches if the data is truncated.
The actual stored key value will be 10 bytes larger than the TSLENGTH to allow for additional text search information in the key.
The UPPER() or LOWER() functions can be used when creating indexes and when conducting index searches to make them case-insensitive.
The DB_TSINDEX environment variable / symbol must be set to "ON" when building or using Text Search Indexes.
Example
set tslength to 15 use example index on tsword(first_name,1) to shortname
Products
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
