Hi,
I am trying to insert a pdf file into a column of SQL table.
I opened the pdf in notepad++ and it looks something like this
%PDF-1.6
%äãÏÒ
1 0 obj
[/PDF/ImageB/ImageC/ImageI/Text]
endobj
3 0 obj
<</Subtype/Image
/Width 450
/Height 135
/BitsPerComponent 8
/ColorSpace/DeviceRGB
/Filter/DCTDecode
/Length 4 0 R
>>
stream
ÿØÿà
I tried using column of datatype varbinary(max) as many threads have proposed but the above pdf doesnt seem to be in binary format.
So the insert failed.
Then I tried using column of datatype varchar(max). This also gave an error ( Unclosed quotation mark after the character string...) since I found
several single quotes in the pdf file when opened in notepad++
Any help on how can I successfully insert the pdf.
Thanks.
Go to the complete details ...