search string in varbinary column of SQL Server table
I have a table which has 3 columns:
- ProblemID
- FileContent
- FileName
I want to search for a user specified string from the fileContent
column. Is it possible to convert binary data in VARCHAR
? I tried it but it gives results in different format.
i am sto开发者_如何学Goring .pdf files only
You can't search real binary data in SQL Server if the binary format is Word or Excel or anything except a raw text file
精彩评论