![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Product Manuals » DBISAM Version 4 Manual for RAD Studio 12 (Delphi Win32) » Advanced Topics » Full Text Indexing |
Parameter | Description |
Stop Words List | The stop words list is a list of words that are to be excluded from the full text index. These words are usually very common words and excluding them from the full text index can result in tremendous space savings for the physical index. The default stop words for a table are as follows: A AN AND BE FOR HOW IN IS IT OF ON OR THAT THE THIS TO WAS WHAT WHEN WHICH WHY WILL The stop words list is always case-insensitive, as is the full text indexing in general. |
Space Characters | The space characters specify which characters in the ANSI character set are to be used for word separator characters. These characters usually consist of any character below the ordinal value of 33 and other separators such as backslashes (\)and commas (,). The default space characters for a table are as follows: Characters 1 through 32 *+,-./:;<=>\ |
Include Characters | The include characters specify which characters in the ANSI character set are to be included in the words that are finally used for the full text index. These characters usually consist of all alphanumeric characters as well as all high character values in the ANSI character set that are used by non-English languages for accented characters and other diacritically-marked characters. The default include characters for a table are as follows: 0123456789 ABCDEFGHIJKLMNOPQRSTUVWXYZ_ abcdefghijklmnopqrstuvwxyz €‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™ š›œžŸ ¡¢£¤¥¦§¨©ª«¬®¯°±²³ ´µ¶·¸¹º»¼½¾¿ÀÁÂÃÄÅÆÇÈÉÊËÌÍ ÎÏÐÑÒÓÔÕÖ×ØÙÚÛÜÝÞßàáâãäåæç èéêëìíîïðñòóôõö÷øùúûüýþ |
begin with MyTable do begin Filter:='TEXTSEARCH('+QuotedStr('DATABASE QUERY SPEED')+ ' IN TextBody)'; Filtered:=True; end; end;
begin with MyTable do begin Filter:='TEXTSEARCH('+QuotedStr('DATABASE')+ ' IN TextBody) OR '+ 'TEXTSEARCH('+QuotedStr('QUERY')+ ' IN TextBody) OR '+ 'TEXTSEARCH('+QuotedStr('SPEED')+ ' IN TextBody)'; Filtered:=True; end; end;
begin with MyTable do begin Filter:='TEXTSEARCH('+QuotedStr('DATA*')+ ' IN TextBody)'; Filtered:=True; end; end;
SELECT GroupNo, No, TEXTOCCURS('DATABASE QUERY SPEED' IN TextBody) AS NumOccurs FROM article WHERE TEXTSEARCH('DATABASE QUERY SPEED' IN TextBody) ORDER BY 3 DESC
This web page was last updated on Thursday, November 16, 2023 at 10:39 AM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |