0

Is it possible to view inserted image in android? Which app should I use? I using SQLite Debugger to access database contents and seeing a <BLOB> in the image column. Does it has a way to see the image inserted in SQLite Debugger?

Hoo
  • 1,806
  • 7
  • 33
  • 66
  • See Answer for Similar Question here :[http://stackoverflow.com/questions/7331310/how-to-store-image-as-blob-in-sqlite-how-to-retrieve-it](http://stackoverflow.com/questions/7331310/how-to-store-image-as-blob-in-sqlite-how-to-retrieve-it) – Vishal Bhadani Nov 07 '15 at 06:20
  • @VishalBhadani If I just want to view inserted image in real device, what should I do – Hoo Nov 07 '15 at 06:26

1 Answers1

0

Just Query Table

Cursor cur=your query;
while(cur.moveToNext())
{
     byte[] photoblob=cur.getBlob(index of blob column);
}


Now Convert byte[] photo to image:

ByteArrayInputStream imagestrm = new ByteArrayInputStream(photoblob);
Bitmap img= BitmapFactory.decodeStream(imagestrm);

Now you can set Bitmap to Imageview.

I hope you will get my point.

Vishal Bhadani
  • 131
  • 6