SQL Server全文搜索无法处理PDF文件

Question

我的全文搜索适用于doc和docx，但不适用于pdf。过滤器的pdf完整路径为：C:\WINDOWS\system32\WINDOWS.Data.pdf.dll版本：6.2.19041.1023告诉我可能是怎么回事？

CREATE TABLE [dbo].[FilesSearch](
[id] [bigint] IDENTITY(1,1) NOT NULL,
[rConclusionCard] [bigint] NOT NULL,
[rConclusionCardFile] [bigint] NOT NULL,
[FileAgreementContent] [varbinary](max) NOT NULL,
[FileAgreementName] [nvarchar](255) NOT NULL,
[FileExt]  AS (lower(reverse(substring(reverse([FileAgreementName]),(0),charindex('.',reverse([FileAgreementName]))+(1))))),
CONSTRAINT [PK_ASM_CONCLUSIONCARD_FILESSEA] PRIMARY KEY CLUSTERED 
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Index [UI_ConclusionCardFile]    Script Date: 13.03.2022 22:07:57 ******/
CREATE UNIQUE NONCLUSTERED INDEX [UI_ConclusionCardFile] ON [dbo].[FilesSearch]
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
/****** Object:  FullTextIndex     Script Date: 13.03.2022 22:07:57 ******/
CREATE FULLTEXT INDEX ON [dbo].[FilesSearch](
[FileAgreementContent] TYPE COLUMN [FileExt] LANGUAGE 'Russian')
KEY INDEX [UI_ConclusionCardFile]ON ([FTConclusionFileSearch], FILEGROUP [PRIMARY])
WITH (CHANGE_TRACKING = AUTO, STOPLIST = SYSTEM)
CREATE FULLTEXT CATALOG [FTConclusionFileSearch] WITH ACCENT_SENSITIVITY = ON 
AUTHORIZATION [dbo] 

Answer 1

您的FileExt列似乎有点偏离，正在添加.。因此，从中删除+ 1。

[FileExt]  AS (lower(reverse(substring(reverse([FileAgreementName]),(0),charindex('.',reverse([FileAgreementName])))))),

然后重建索引

ALTER FULLTEXT CATALOG FTConclusionFileSearch REBUILD;