python (65.2k questions)

javascript (44.3k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (13k questions)

Questions - full-text-catalog

SQL Server Full-Text Search not working on PDF File

My full text search works with doc and docx but not working with pdf. The filters have pdf fullpath: C:\WINDOWS\system32\Windows.Data.Pdf.dll version: 6.2.19041.1023 Tell me what could be the matter? ...
test-img

zig8953

sql-server

full-text-search

fulltext-index

full-text-catalog

Votes: 0

Answers: 1

Latest Answer

It seems that your FileExt column was a bit off, and was adding in the .. So remove the + 1 from it. [FileExt] AS (lower(reverse(substring(reverse([FileAgreementName]),(0),charindex('.',reverse([...
test-img

Charlieface

Posts

Questions

Blogs

Jobs