Storing an image encoded in base64 from android via php in mysql

Question

I've been trying to store images in mysql database by encoding them in a base64 string then passing them to a php script that in turn stores this string in a blob (I also tried text) filed. What happens is the string is sent to the php script as it is, but when stored in the database, its is stored as a completely different string.

Here is how i do it:

    Bitmap image = BitmapFactory.decodeFile("/sdcard/photo2.jpg");

    ByteArrayOutputStream stream = new ByteArrayOutputStream();
    image.compress(Bitmap.CompressFormat.PNG, 100, stream);

    byte[] byteImage = stream.toByteArray();

    String s = Base64.encodeToString(byteImage, Base64.NO_WRAP | Base64.URL_SAFE);

And then the string 's' is passed to the php script (correctly as I've checked it) and the script in turn insert it in the database.

This link http://diffchecker.com/kKD4w16C contains how the original encoded string (on the left of the screen) and the string that is stored in the database (on the right of the screen).

Any ideas why this is happening and how to prevent it?

Thanks in advance.

Hey.. u dont notice, that u just cut on ~20% of string? seems like there is limit for your DB field. something like varchar(255) and u try to store 1500 length string. — StasGrin
– StasGrin, Commented Nov 20, 2012 at 14:48
@StasGrin : me too , there is no difference between your strings , i think your encodage type in your database is different , use UTF8 — Houcine
– Houcine, Commented Nov 20, 2012 at 14:49
tinyurl.com/c2e7hru - see here. i just copy the end of your DB field value and find it in "original" value — StasGrin
– StasGrin, Commented Nov 20, 2012 at 14:52
Thanks guys, I changed the field to longblob and the encoding to utf-8 and it worked. — askso
– askso, Commented Nov 20, 2012 at 15:07

StasGrin · Accepted Answer · 2012-11-20 15:14:41Z

2

You dont notice, that u just cut on ~20% of string? Seems like there is limit for your DB field. Something like varchar(255) and u try to store 1500 length string.

http://tinyurl.com/c2e7hru - see here. I just copy the end of your DB field value and find it in "original" value.

Also, check your encoding.

answered Nov 20, 2012 at 15:14

StasGrin

1,8082 gold badges15 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

Storing an image encoded in base64 from android via php in mysql

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related