There is an inverse relationship between the number of
characters a character set supports in an index and the number of
characters in a clue word that are searched. The following table shows
how many characters each character set supports in an index and the
number of characters in a clue word that are searched for that character
set.
Character set |
Max number of characters in index |
Number of characters searched in clue
word |
ASCII |
62 |
First 24 |
OVERLAP_ISO |
124 |
First 20 |
ISO |
124 |
First 20 |
User specified |
256 |
First 16 |
For example, in an index created with a user-defined character
set, only the first 16 characters of a clue word are used in the search.
This means that any word in the index that matches the first 16 characters
of the clue word is a hit. In the following query the clue is
nonintercompatibility:
select title from reports
where etx_contains(abstract, 'nonintercompatibility');
A
search returns both nonintercompatible and nonintercompatibility as
exact word matches.