What you're looking for in SQLite is called a BLOB (Binary Large Object) but this is usually NOT recommended, the better approach would be to add the images to your MediaStore and then store the file path in your SQLite database. Then you can retrieve the images as needed from the resource path like this:
BitmapFactory.Options options = new BitmapFactory.Options(); options.inSampleSize = 2; options.inTempStorage = new byte[16*1024]; options.inJustDecodeBounds = false; Bitmap preview = BitmapFactory.decodeStream(getContentResolver().openInputStream(imagePath),null,options); Hope this helps. On Aug 22, 3:04 pm, Abhi <[email protected]> wrote: > Hi > > I have a database of low res images that I am trying to use for one of > my applications. What I would like to do is to retrieve the images one > by one and display them in a slideshow. I was told that images are > stored as byte arrays in sql database. I am new to sql and looking for > some direction on how to do this, what query to put and how to extract > the byte array from the database for further use. > > Any help appreciated. > > Thanks, > AB -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en
