Binary data in cursor android

Question

I am saving a bitmap value in SQLite by encoding it into base64. I need to create a JSON array for all my SQLite values. I am using a a cursor to get all my values from SQLite.

But the cursor does not hold the whole base64 value, only half base64 bits.

How can I resolve this?

P.S. Ensure that the column of SQLite in which you are storing base64 encoded string has at least length greater than or equal to encoded string length. — Vipul Asri
– Vipul Asri, Commented Nov 11, 2016 at 6:24

Community · Accepted Answer · 2017-05-23 11:53:06Z

2

I think its not the best practice to save base64 representation in db:

Please remember base64 encoding makes file sizes roughly 33% larger than their original binary representations, So you can convert image to byte[] and then save it in blob field

To save binary data in JSON Object, please see here

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Nov 11, 2016 at 6:19

Muhammad Farhan Habib

1,8091 gold badge20 silver badges23 bronze badges

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

Collectives™ on Stack Overflow

Binary data in cursor android

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related