Upvote:2
//Storage
UIImage *image = ...; //Retrieve image from URL
NSData *imageData = UIImagePNGRepresentation(image);
sqlite3_bind_blob(compiledStatement, 1, [imageData bytes], [imageData length], NULL);
//Retrieval
const void *data = sqlite3_column_blob(compiledStatement, 1);
int length = sqlite3_column_bytes(compiledStatement, 1);
UIImage *retrieved = [UIImage imageWithData:
[NSData dataWithBytes:data length:length]];
Credit Goes to: stackoverflow.com
Related question with same questions but different answers
- HOW CAN I READ IMAGE AS BINARY DATA FROM DATABASE USING OBJECTIVE-C? IN IOS
- FMDB TO READ FROM DATABASE FOR AN IPHONE APPLICATION IN IOS
- ALTERNATE WAY TO RETRIEVE DATA FROM CORE DATA DATABASE - IOS IN IOS
- GET DATA FROM SERVER OBJECTIVE-C IN IOS
- ROTATING BUTTON WHEN DOWNLOADING DATA FROM SERVER IN IOS
- SWITCH FROM SYNCHRONOUS REQUEST TO ASYNCHRONOUS REQUEST WITH IMAGE UPLOAD? IN IOS
- GETTING DATA FROM A REMOTE SQL SERVER - IPHONE SDK IN IOS
- SENDING GET REQUEST TO SERVER AND GETTING GENERATED HTML PAGE DATA FROM IT IN IOS IN IOS
- POPULATE UITABLEVIEW AND DETAILSVIEW IN SPLITVIEWCONTROLLER FROM SQLITE DATABASE IN IOS
- UPDATE PLIST FROM BACKGROUND IN IOS
- HOW TO SET UP A DEFAULT IMAGE IN IOS
- HOW TO EXPEND UIBUTTON WIDTH FROM RIGHT TO LEFT ONLY IN IOS
- IS THERE A MINIMALIZED EXAMPLE OF HOW TO USE VERTEX BUFFER OBJECTS (VBO) IN OPENGL ES 1.1? IN IOS
- HOW TO CAPTURE VIDEO FROM IP CAMERA IOS IPAD/IPHONE IN IOS
- LOCATION SERVICES CONTROL FROM IPHONE APP IN IOS
- REMOVING OBJECT FROM NSMUTABLEARRAY AFTER UPGRADING TO SDK 5 FOR IOS CAUSES MY APP TO CRASH IN IOS
- NSPROPERTYLISTSERIALIZATION NOT ABLE TO SET IMAGE STRING FOR A DETAIL VIEW IN A TABLE VIEW (IOS) IN IOS
- CLASS RESULTED FROM NSCLASSFROMSTRING DOES NOT ASSOCIATE WITH CLASS DEFINED IN HEADER FILE IN IOS
- IS THERE A WAY TO USE A RANDOM PROJECT PNG IMAGE FOR A UITABLEVIEWCELL? IN IOS
- ADD IMAGE TO UITEXTVIEW AND POST IT IN IOS
- IOS AND COCOS2D - CHANGING CCSPRITE'S IMAGE AND NEW DIMENSIONS = FAIL IN IOS
- HOW TO GET SELECTED DATE FROM KAL CONTROL? IN IOS
- IPHONE4 IOS5 HOW TO CONVERT A STRING AS IT'S BINARY CHARACTER CODES PROGRAMMATICALLY? IN IOS
- ASIHTTPREQUEST: (IOS) PROPERLY DOWNLOAD & STREAM DATA TO DISK IN IOS
- ZOMBIE NSSTRING WHEN CALLED FROM ANOTHER OBJECT IN IOS
- DRAW IMAGE ABOVE PDF IOS 5 IN IOS
- ACCESS METHODS OR PROPERTY FROM ANOTHER CLASS WITHOUT CALLING VIEWDIDLOAD? IN IOS
- HOW TO STOP UISCROLLVIEW FROM BEING TEMPORARILY SCROLLED DOWN WHEN AT THE TOP OF THE VIEW IN IOS
- GETTING AN AREACODE FROM THE PHONE NUMBER IN IOS
- HOW TO PASS A STRING FROM ONE TABLEVIEWCONTROLLER TO OTHER TABLEVIEWCONTROLLER USING NAVIGATION IN IOS
- ERROR IN ACCESSING GOOGLE READER'S ENDPOINTS API IN IOS
- SBJSON PARSING ISSUE WITH TWITTER'S GET TRENDS/:WOEID IN IOS
- APP CRASHED ON IPAD SIMULATOR 4.3 ONLY IN IOS
- IOS4.3.4: MFMAILCOMPOSER DOESN'T SEND AN EMAIL, BUT RETURN MFMAILCOMPOSERESULTSENT STATUS IN IOS
- IOS WEB SERVICE LOGIN WITH COOKIE IN IOS
- IOS OPENURL BASED ON TABLE CELL VALUE IN IOS
- CORE DATA FAULT: HOW TO LOAD AN ENTITIES RELATIONSHIP SET OF OBJECTS CORRECTLY IN IOS
- APPLY REGULAR EXPRESSION REPEATEDLY IN IOS
- UITABLEVIEW ACTION ROW IN IOS
- IOS5 UIBUTTON SHOULD I TRY TO OPTIMIZE BACKGROUND IMAGE? IN IOS
- IPAD CREATE A PROGRAMMATICALLY UITABLEVIEWCELL IN IOS
- NSOPERATIONQUEUE FOR SYNCHRONOUS UPLOAD IN IOS
- HOW TO CHANGE DEFAULT TITLE OF THE UITABBARITEM IN IOS
- RESTKIT. RKOBJECTMANAGER AND QUEING IN IOS
- PARSE ELEMENTS WITH SAME NAMES BUT WITH DIFFERENT ATTRIBUTES IN IOS
- EXTENDING A PROTOCOL TO EXTEND DELEGATE METHODS FOR NSURLCONNECTION IN IOS
- RETRIEVE *ONLY* THE ALASSETSGROUP CORRESPONDING TO THE "CAMERA ROLL" IN IOS
- IMPORT, PARSE, EDIT AND SAVE RTF DOCUMENTS WITH FORMATTING PRESERVED IN IPAD AND DROID APPS IN IOS
- I CAN'T INSERT AN OBJECT IN A NSMUTABLEARRAY WHEN I PARSE A XML IN IOS
- DECLARING FUNCTIONS USING NSARRAY AS AN ARGUMENTS IN IOS
- CORETEXT SPACE BETWEEN LINES IN MULTILINE IN IOS
- HOW TO CREATE DYNAMIC BUTTONS OVER DYNAMIC IMAGEVIEWS WHILE MAINTAINING THE UNIQUENESS IN IOS
- HOW TO ADD A ONCE ONLY SECTION AND SECTION TITLES TO A UITABLEVIEW? IN IOS
- HOW TO HORIZONTALLY ALIGN UNDERSCORE WITHOUT REPEATING IT? IN IOS
- IOS UITABLEVIEW CELL LOADS INCORRECTLY AFTER SCROLL? IN IOS
- UISEARCHDISPLAYCONTROLLER, WHAT'S THE REFERENCE TO THE UITABLEVIEW ? IN IOS
- LOADING AND CHANGING IMAGES ASYNCHRONOUS IN IOS