full-text-searchdocxopenxml-sdkfulltext-indexfull-text-catalog

Negative numbers not indexed numbers without negative symbol in full text catalog


I store a docx file in sql server database that contains negative number like -56653. I installed Microsoft Filter Pack 2.0 and execute this code:

EXEC sp_fulltext_service 'update_languages'; 
EXEC sp_fulltext_service 'load_os_resources', 1;
EXEC sp_fulltext_service 'restart_all_fdhosts'; 

Then rebuild the Full Text Catalog multiple time, When search 56653, the query not found any things, but when search -56653 the query work fine.

SELECT *
FROM Files
WHERE
   (CONTAINS([Files].[Content], '"56653"'))

Does somebody know what is the problem?


Solution

  • Finally I found the problem. Full text catalog not indexed content of table which inside a paragraph!

    This mean the w:tbl tag move to outside of w:p tag.

    <w:p w:rsidR="00E402AA" w:rsidP="00E402AA" w:rsidRDefault="00E402AA">
      <w:pPr>
        <w:bidi />
          <w:spacing w:after="0" w:line="240" w:lineRule="auto" />
          <w:jc w:val="both" />
          <w:rPr>
            <w:bCs />
            <w:sz w:val="24" />
          </w:rPr>
       </w:pPr>
        <w:r>
          <w:rPr>
            <w:bCs />
            <w:sz w:val="24" />
          </w:rPr>
        </w:r>
    
        <!-- Start Table -->
        <w:tbl>
          <w:tblPr>
            <w:tblStyle w:val="TableGrid" />
            <w:tblW w:w="5000" w:type="pct" />
          </w:tblPr>
          <w:tr>
            <w:tc>
              ...
            </w:tc>
          </w:tr>
        </w:tbl>
        <!-- End Table -->
    </w:p>