开发者

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜