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

martinrybak / SQLClient

Native Microsoft SQL Server client for iOS

http://objcsharp.wordpress.com/2013/10/15/an-open-source-sql-server-library-for-ios/

MIT License

125 stars 51 forks source link

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

Closed indieshack closed 4 years ago

indieshack commented 4 years ago

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?

indieshack commented 4 years ago

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.