I'm trying to create a contractor database which indcludes a copy of their resume and has to A) be searchable and B) export the resume as PDF. My co-workers told me that putting the PDF in a table as an image datatype would allow me to search on it directly. I'm not sure if this is possible, but I've been trying it out.
So I've put in the image datatype column and put in two records - one is a PDF and one is a plain text file. I've enabled full-text searching on this database, table, and column and have tried searching with the following:
SELECT * FROM TABLE1 WHERE CONTAINS (Resume,' "Source" ')
Unfortuantely, this doesn't return any records. Do you know what I'm doing wrong, or if searching the contents of a PDF file via SQL is even possible?