Get boolean from database using Android and SQLite

Question

How can I obtain the value of a boolean field in an SQLite database on Android?

I usually use getString(), getInt(), etc. to get the values of my fields, but there does not seem to be a getBoolean() method.

score 361 · Accepted Answer · edited Jan 20 '16 at 03:04

361

It is:

boolean value = cursor.getInt(boolean_column_index) > 0;

edited Jan 20 '16 at 03:04

Peter Mortensen

30,738
21
105
131

answered Nov 03 '10 at 14:34

Alex Orlov

18,077
7
55
44

31

cursor.getInt(boolean_column_index) != 0 is more standard C. – David Stocking Feb 28 '14 at 21:53
2

@Buttink `>0` is shorter in bytes though :P – Gurupad Mamadapur Feb 09 '17 at 14:52
stackoverflow 不爱不行 – linjiejun Jan 07 '21 at 02:40
For an optional (nullable) Boolean, see answer below: https://stackoverflow.com/a/65828389/7493938 – Mario Huizinga Jan 21 '21 at 13:26

score 46 · Answer 2 · edited Jan 20 '16 at 03:05

46

There is no bool data type in SQLite. Use an int that you fix to 0 or 1 to achieve that effect. See the datatypes reference on SQLite 3.0.

edited Jan 20 '16 at 03:05

Peter Mortensen

30,738
21
105
131

answered Nov 03 '10 at 14:32

NG.

22,560
5
55
61

score 24 · Answer 3 · answered Nov 25 '11 at 16:13

24

boolean value = (cursor.getInt(boolean_column_index) == 1);

answered Nov 25 '11 at 16:13

Elvis

831
7
9

Even though not exactly corresponding to this question (Alex's is the closest), it's an excellent answer, and I'll use this. – Budimir Grom Dec 16 '14 at 15:34

Sojurn · Answer 4 · 2013-10-12T09:21:04.397

11

Most of the answers here can result in NumberFormatExceptions or "operator is undefined for the types null, int" if the column you stored the int in was allowed to also hold null. The decent way to do this would be to use

Boolean.parseBoolean(cursor.getString(booleanColumnIndex));`

though you are now limited to storing the strings "true" and "false" rather than 0 or 1.

edited Oct 12 '13 at 09:21

answered Oct 16 '12 at 07:42

Sojurn

475
6
15

5

This does not work. Boolean.parseBoolean takes "true" or "false" strings. If you have stored your boolean as 0 or 1 you will always get false. – Gober Jul 17 '13 at 12:32
If what Gober says is true, then this answer deserves to be downvoted – Shervin Asgari Oct 11 '13 at 18:16
Ah, he's right. I think the clarity of the result outweighs having to store the strings. – Sojurn Oct 12 '13 at 09:22
1

@ShervinAsgari in the other answer if you store your boolean as true or false it will always get false. So it should be downvoted too with your logic. – Arda Kara Jul 26 '16 at 16:17

score 6 · Answer 5 · edited Dec 12 '13 at 02:21

6

An implementation found at Ormlite Cursor also checks for Null which none of the other answers do.

   public boolean getBoolean(int columnIndex) {
        if (cursor.isNull(columnIndex) || cursor.getShort(columnIndex) == 0) {
            return false;
        } else {
            return true;
        }
    }

edited Dec 12 '13 at 02:21

Szymon

42,577
16
96
114

answered Dec 12 '13 at 02:00

rtack

183
3
10

score 6 · Answer 6 · edited Apr 22 '15 at 15:02

6

You can also use

boolean value =cursor.getString(boolean_column_index).equals("True");

edited Apr 22 '15 at 15:02

AndyD273

7,177
12
54
92

answered Jul 29 '11 at 13:47

zoeb

69
1
1

5

equals() not contains – Shervin Asgari Oct 11 '13 at 18:16

Ravi · Answer 7 · 2016-01-20T04:12:51.693

4

boolean datatype is not available in Cursor.

you will get the result in an int, so you need to convert that int value to a boolean.

You can either use

boolean b = cursor.getInt(boolean_column_index) > 0;

or

boolean b = (cursor.getInt(boolean_column_index) != 0);

edited Jan 20 '16 at 04:12

answered Dec 29 '15 at 06:40

Ravi

34,851
21
122
183

score 2 · Answer 8 · answered Jun 04 '13 at 19:59

2

Another option

boolean value = (cursor.getString(column_index)).equals("1");

answered Jun 04 '13 at 19:59

Gokhan Arik

2,626
2
24
50

RedBullet · Answer 9 · 2016-06-07T13:13:41.243

2

boolean b = (cursor.getInt(cursor.getColumnIndex("item")) != 0);

edited Jun 07 '16 at 13:13

answered Nov 20 '14 at 15:53

RedBullet

21
3

score 1 · Answer 10 · answered May 20 '21 at 11:34

thats what I used:

    val work = Work()
    work.id = cursor.getInt(0)
    work.date = cursor.getString(1)
    work.work_value = cursor.getFloat(2)
    work.place = cursor.getString(3)
    work.wind = cursor.getFloat(4)
    work.isCompetition = cursor.getInt(5) > 0
    return work

score 0 · Answer 11 · answered Aug 30 '19 at 05:22

Well, that's very simple:

public boolean getBooleanState(SQLiteDatabase db){
    boolean result = false;
    try{
        String QUERY = "SELECT " + BOOLEAN_DATA + " FROM " + TABLE_NAME + " WHERE " + ID + " = 1";
        Cursor cursor = db.rawQuery(QUERY, null);
        if (cursor.moveToFirst()){
            if(cursor.getString(0).equalsIgnoreCase("1")){
                result = true;
            }
        }
        c.close();
    }catch(Exception ee){
        Log.e(TAG, "err getBooleanState: " + TABLE_NAME );
    }
    return result;
}

score 0 · Answer 12 · answered Jan 21 '21 at 13:23

For an optional (nullable) Boolean stored as INTEGER, you can create a Kotlin extension:

fun Cursor.getBoolean(columnIndex: Int): Boolean? {
    return if (isNull(columnIndex))
        null
    else 
        getInt(columnIndex) != 0
}

and use it like this:

val value: Boolean? = cursor.getBoolean(boolean_column_index)

score 0 · Answer 13 · edited Aug 25 '22 at 06:57

0

I face the same thing in kotlin. There was the value "true/false" in the database and I access it with this code:

cursor.getString(4).toBoolean()

//first as a string then converting them to boolean

edited Aug 25 '22 at 06:57

Procrastinator

2,526
30
27
36

answered Aug 21 '22 at 03:24

Dev Pandey

1
1

Get boolean from database using Android and SQLite

13 Answers13

Linked

Related