asked on Searching varbinary field quickly
SQL Server
ASP.NET
I have a varbinary field that stores the content of various documents such as pdfs, docs, csvs, etc.
What is the best method for searching the varbinary field quickly?
Does indexing it help? etc.?
thanks!
ASP.NET
I have a varbinary field that stores the content of various documents such as pdfs, docs, csvs, etc.
What is the best method for searching the varbinary field quickly?
Does indexing it help? etc.?
thanks!
Microsoft SQL ServerASP.NETSQL
Last Comment
Starr Duskk
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Sorry, yes, I intend to search using a SQL Query, not client side.
We have found we can search these results if the file is csv and return rows, and some pdfs show up, but other pdfs do not find the asked for data.
We have found we can search these results if the file is csv and return rows, and some pdfs show up, but other pdfs do not find the asked for data.
Some PDFs do not contain text info in open text and/or they can have just image format. In such case you would need OCR to read them which is hard to implement on the SQL Server.
ASKER
Thanks pcelba! With your advice, we were able to make it work. Great answer!
products
ID int
data varbinary
author varchar(max)
date datetime
tags varchar(50)