martinrybak/SQLClient

Still having issues with truncation pulling binary data from varbinary field sql server

indieshack opened this issue · 1 comments

I found a few issues that refer to this, and the solution recommended is to use the latest "types" branch - by which I assume the master branch. But pulling image data from a varbinary field is still truncating. Do I need to set a parameter before the sql query?

OK - using this in a Cocoa app - in case it's of help to anyone else - I wasn't able to change the default the text size value from 4096 in the SQLClient API - setting it did nothing to the value on the server. Instead, I needed to prefix my retrieval SQL with "SET TEXTSIZE X;" where 'X' is the new text size you need to pull.