PDF into SQL DB

  • SO....I have a ?, are PDF's considered LOB?

    MCSE SQL Server 2012\2014\2016

  • Are you trying to insert the entire PDF into a column in a table in your database? It's not entirely clear from your post.

  • Well here is the thing, I have a user that is copying a PDF from a DB to DB in SharePoint, there is a timeout issue that is being addressed however I thought that if a PDF was considered a LOB since it could be a IMAGE in a column that this could be an issue and wanted thoughts on whether it is considered a LOB.

    MCSE SQL Server 2012\2014\2016

  • Yes it is a LOB. To select\insert the PDF you need to call the appropriate stream reader\writer to access the binary column in the table where the PDFs are stored.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • Thank you Perry!

    MCSE SQL Server 2012\2014\2016

Viewing 5 posts - 1 through 4 (of 4 total)

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