Generic method of converting SQLite BLOB to byte array (POJO)

Question

I am working with a third party SQLite database. It has a BLOB column that may contain an image, video or audio file. Of course, there is another column that specifies the mime type of the BLOB. My question is, is there a generic way of converting from BLOB to byte array and byte array to blob. I have seen tons of examples around the web but they are specific to images. I am looking for a generic method of working with the blob regardless of it's type.

NOTE: I know it is not a good idea to save these types of files in the db but in this case I have no choice.

Janki Gadhiya · Accepted Answer · 2016-06-29 10:42:59Z

2

The Android database API already used byte arrays to represent blobs; no conversion is needed.

edited Jun 29, 2016 at 10:42

Janki Gadhiya

4,5103 gold badges31 silver badges59 bronze badges

answered Apr 20, 2014 at 7:54

CL.

182k18 gold badges241 silver badges282 bronze badges

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

Collectives™ on Stack Overflow

Generic method of converting SQLite BLOB to byte array (POJO)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related