2014/10/15 下午 10:14:22

iphone Programming Glossary: sqlite3_bind_blob

http://stackoverflow.com/questions/10192945/to-reterive-blob-image-from-sqlite

SQLITE_OK sqlite3_prepare_v2 database insert_stmt 1 addStatement NULL if sqlite3_step addStatement SQLITE_DONE sqlite3_bind_blob addStatement 1 imageData bytes imageData length SQLITE_TRANSIENT NSLog @ Data saved else NSAssert1 0 @ Error while updating... Although you try to bind a blob here it does not get bound to anything since you do not include a parameter template. sqlite3_bind_blob addStatement 1 imageData bytes imageData length SQLITE_TRANSIENT To fix this here is a minimal example query does not need.. of the values here before you execute the statement sqlite3_bind_text addStatement 1 nameString UTF8String 1 NULL ... sqlite3_bind_blob addStatement 9 imageData bytes imageData length SQLITE_TRANSIENT if sqlite3_step addStatement SQLITE_DONE NSLog @ Data..

Inserting NSData into SQLite on the iPhone

http://stackoverflow.com/questions/3319791/inserting-nsdata-into-sqlite-on-the-iphone

manipulation nsdata share improve this question I would use sqlite3_stmt instead of a string. Then you could use sqlite3_bind_blob to bind the blob to the prepared statement. sqlite3_stmt insert_statement char sql INSERT INTO table blobcolumn column2.. blobcolumn column2 column3 VALUES if sqlite3_prepare_v2 database sql 1 insert_statement NULL SQLITE_OK handle error sqlite3_bind_blob insert_statement 1 dataForImage bytes dataForImage length NULL But really it would be best for performance to store the..

Retrieve nsdata from sqlite stored in Blob data type for iPhone App

http://stackoverflow.com/questions/4724118/retrieve-nsdata-from-sqlite-stored-in-blob-data-type-for-iphone-app

store and retrieve image into sqlite database for iphone

http://stackoverflow.com/questions/8728834/store-and-retrieve-image-into-sqlite-database-for-iphone

compiledStmt 3 model.imgurl UTF8String 1 SQLITE_TRANSIENT NSData imageData UIImagePNGRepresentation imageView.image sqlite3_bind_blob compiledStmt 4 imageData bytes imageData length NULL if sqlite3_prepare_v2 database insertSQL 1 compiledStmt NULL SQLITE_OK..