Converting Bitmap Image to Byte Array and Store into Mysql

Question

I am a nooby android developer and am trying to convert bitmap image into byte array and store that value in Mysql database.

The following code is working great and the value is stored in the database, but am not sure if this is the real image or not..

Here's the code am using to convert the image:

Bitmap bitmap = BitmapFactory.decodeFile(file_path);
         ByteArrayOutputStream blob = new ByteArrayOutputStream();
         bitmap.compress(CompressFormat.JPEG,100, blob);

         bitmapdata = blob.toByteArray();

         //System.out.println(blob.toByteArray());

         bitmap.recycle();
         bitmap = null;

         photo_string = bitmapdata.toString();
         System.out.print(photo_string);
         try {
                blob.close();
                blob = null;
            } catch (IOException e) {
                // TODO Auto-generated catch block
                e.printStackTrace();


}

and here's the HttpPost part:

HttpClient client = new DefaultHttpClient();
HttpPost post = new HttpPost("InsertIntoDB.php");
pairs.add(new BasicNameValuePair("img",photo_string ));
post.setEntity(new UrlEncodedFormEntity(pairs));
HttpResponse response = client.execute(post);

The value stored in DB is something like: [B@4285096

is the really the image itself ?? Please help with that.

Matt · Accepted Answer · 2014-07-15 11:56:40Z

1

Yes. The value you are seeing is the byte array for image.

edited Jul 15, 2014 at 11:56

Matt

75.4k26 gold badges156 silver badges181 bronze badges

answered Apr 12, 2014 at 7:43

Aditya_Anand

5658 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

12 Comments

Izzo32 Over a year ago

Thank you so very much, i spent the whole day checking if it's the byte array or not... :) Thanks

Ravinder Reddy Over a year ago

@Izzo32: No it is not. Image data is not stored in db correctly.

Ravinder Reddy Over a year ago

Can you show the code how you are reading image data from the database?

Aditya_Anand Over a year ago

but the thing that is saved in db is definately the byte array of a image

Ravinder Reddy Over a year ago

But what OP says is value stored in DB is something like: [B@4285096

|

Collectives™ on Stack Overflow

Converting Bitmap Image to Byte Array and Store into Mysql

1 Answer 1

12 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

12 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related