[sqlite] Retrieved Blob Data has 16 Byte Header or ?

2016-01-21 Thread Rooney, Joe
Ok, Kyle McKay responded directly offline with the solution. On my call: NSData *picData; sqlite3_bind_blob(preparedStatement, empProfPicDataPos, [picData bytes], picBytes, SQLITE_TRANSIENT); I had originally used picData, not [picData bytes]. And therein lies the fact that given I rarely

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

2016-01-19 Thread Christian Schmitz
> NSData doesn't involve encryption, but it does involve tagging the data with > metadata, e.g. the fact that it's a string, and how long the string is. > There is an NSData accessor function which returns the length of the > /content/ of the object. Or, of course, you can obtain the length of

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

2016-01-19 Thread Christian Schmitz
> * Retrieve Blob to NSData object - 3245 bytes > > * The retrieved data will not display. Do you pass it though encryption? 16 bytes sounds like an IV for AES stored before the data. Sincerely Christian -- Read our blog about news on our plugins: http://www.mbsplugins.de/

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

2016-01-19 Thread Simon Slavin
On 19 Jan 2016, at 9:13am, Christian Schmitz wrote: >> * Retrieve Blob to NSData object - 3245 bytes >> >> * The retrieved data will not display. > > Do you pass it though encryption? > > 16 bytes sounds like an IV for AES stored before the data. NSData doesn't involve

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

2016-01-19 Thread Hick Gunter
[mailto:sqlite-users-bounces at mailinglists.sqlite.org] Im Auftrag von Rooney, Joe Gesendet: Dienstag, 19. J?nner 2016 00:46 An: sqlite-users at mailinglists.sqlite.org Betreff: [sqlite] Retrieved Blob Data has 16 Byte Header or ? The process, working in iOS: * Retrieve an employee photo

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

2016-01-19 Thread Simon Slavin
On 18 Jan 2016, at 11:46pm, Rooney, Joe wrote: > * Convert Base64 string to NSData object - 3245 bytes > > * Store NSData object to a Blob in SQLite - 3245 bytes > > * Retrieve Blob to NSData object - 3245 bytes > Store the string in the BLOB rather than the NSData

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

2016-01-18 Thread Rooney, Joe
The process, working in iOS: * Retrieve an employee photo using web service call, encoded in Base64 string * Convert Base64 string to NSData object - 3245 bytes * Store NSData object to a Blob in SQLite - 3245 bytes * Retrieve Blob to NSData object - 3245

[sqlite] Retrieved Blob Data has 16 Byte Header or ?

2016-01-18 Thread Richard Hipp
On 1/18/16, Rooney, Joe wrote: > The process, working in iOS: > > > * Retrieve an employee photo using web service call, encoded in > Base64 string > > * Convert Base64 string to NSData object - 3245 bytes > > * Store NSData object to a Blob in SQLite - 3245 bytes > > *