Difference between revisions of "SET TSLENGTH"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET TSLENGTH=
 
 
 
==Class==
 
Text Searching
 
 
 
 
==Purpose==
 
==Purpose==
 
Specify size of Text Search Index key
 
Specify size of Text Search Index key
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[INDEX]], [[KEY()]], [[LOWER()]], [[NDX()]], [[TSPOS()]], [[TSWORD()]], [[UPPER()]], [[SET INDEX]], [[SET ORDER]], [[DB_TSINDEX]]
+
[[DB_TSINDEX]], [[INDEX]], [[KEY()]], [[LOWER()]], [[NDX()]], [[SET INDEX]], [[SET ORDER]], [[TSPOS()]], [[TSWORD()]], [[UPPER()]]
  
  
Line 29: Line 22:
  
 
==Example==
 
==Example==
<pre>
+
<code lang="recital">
 
set tslength to 15
 
set tslength to 15
 
use example
 
use example
index on tsword(first_name,1) to shortname</pre>
+
index on tsword(first_name,1) to shortname
 +
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|TSLENGTH]]
 
[[Category:Set_Commands|TSLENGTH]]

Latest revision as of 15:44, 25 November 2009

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 Server, Recital