Searching within a blob/image file.

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

dbo.benyos SSCommitted Points: 1944 More actions · Answer 1

HI

You might wanna check Full Text Indexing in BOL, but I dout it can find HEX strings correctly...

If not - your only option (still better than Access) is to use PATINDEX or LIKE

Jeff Bradshaw Valued Member Points: 50 More actions · Answer 2

But can I do a PatIndex or Like on a blob object? I thought you had to pull the blob out of the database first and then process it?

Can you treat it just like any other column in that respect.

Using SQL Server 2005.

dbo.benyos SSCommitted Points: 1944 More actions · Answer 3

Yes.

Patindex and LIKE are able to treat TEXT columns. Other string functions aren't.

Jeff Bradshaw Valued Member Points: 50 More actions · Answer 4

But I'm not using a text field. I'm using a blob (I'm assuming it's an image but I don't have access to the DB yet)

dbo.benyos SSCommitted Points: 1944 More actions · Answer 5

Well...BLOB is an old term, back from the SQL 6.5/ACESS era...

Your data is probably placed inside a varbinary column.

Have a look at this:

Jeff Bradshaw Valued Member Points: 50 More actions · Answer 6

I found out what the table is and it's an image type.