Read blob from database Android

Question

I have a pre-built database, I used SQLiteMan to populate database that contains short stories or articles, so I have a table structure like this:

Table: texts
id - integer auto increment
title - text
content - blob

The content field contains a paragraph text or strings from a text file I edited from a text editor.

How can I retrieve the contents from the database as text?

Furqi · Accepted Answer · 2012-08-06 03:13:41Z

2

You can get your blob data like this.

byte[] byteArray = cursor.getBlob(columnIndex);

answered Aug 6, 2012 at 3:13

Furqi

2,4031 gold badge26 silver badges32 bronze badges

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

Comments

Maks · Accepted Answer · 2012-08-06 03:49:58Z

1

Given that you've asked "as text" I would clarify the previous answer with:

new String(cursor.getBlob(1), "utf-8");

of course if you've used a different character set, then you would specify that instead of utf-8.

answered Aug 6, 2012 at 3:49

Maks

8,0156 gold badges45 silver badges69 bronze badges