Storing PDF and large binary files in MSQL

[Len A]

I am tyring to store PDF files in MSQL- some very large. How do you do this?

I have tried converting to base64 text, then storing as text type,
, then use

toBinary

to write it- but the file that wrtes out only has about half the data in it.
Am I missing something here?

(I want to store many files in the DB, some will be very large (a meg or
so))

Thanks

 

[Blaqb0x]

"Am I missing something here?"

Yes, try asking the question on the MSSQL newsgroup.

 

[Brian Desmond [MVP]]

This is the wrong group for this, but you would want to store it in an image
column.

--
Thanks,
Brian Desmond
Windows Server MVP - Directory Services

www.briandesmond.com