Is there type Long in SQLite?

Question

I want to create a table with the column type Long instead of Integer. Is it possible?

Inder Kumar Rathore · Answer 1 · 2017-10-24T11:00:40.023

249

INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes depending on the magnitude of the value.

Since long is 8 byte and INTEGER can also save values of 8 bytes, you can use INTEGER.

edited Oct 24 '17 at 11:00

answered Feb 01 '14 at 05:51

Inder Kumar Rathore

39,458
17
135
184

1

i input 1549251913000 and mismatch when getting it from SQLite – Nanda Z Feb 04 '19 at 03:28
2

Please check whether you're mistakenly type casting it to `int`, make sure you're using long throughout. – Inder Kumar Rathore Feb 06 '19 at 05:19

score 22 · Answer 2 · edited Jan 02 '17 at 07:51

22

Create the column as an INTEGER type:

db.execSQL("CREATE TABLE IF NOT EXISTS " + TABLE_A + "("
                + KEY + " INTEGER" + ")");

Put the long value in INTEGER column:

contentValues.put(KEY, object.getLongValue());
db.insert(TABLE_A, null, contentValues);

Important: retrieve the value from cursor as LONG

Cursor cursor = db.rawQuery("SELECT * FROM " + TABLE_A, null);
long value = cursor.getLong(0);

edited Jan 02 '17 at 07:51

Rolf ツ

8,611
6
47
72

answered Aug 22 '16 at 16:57

Vasil Valchev

5,701
2
34
39

What's the difference compared to just using `INTEGER` all the way? – ericn Aug 27 '20 at 02:06

score 18 · Answer 3 · answered Dec 29 '11 at 19:34

18

I don't think there is type long. Either you can use INTEGER (or) Numeric. Here is link with supported data types http://www.sqlite.org/datatype3.html

answered Dec 29 '11 at 19:34

kosa

65,990
13
130
167

score 5 · Answer 4 · answered May 06 '13 at 08:00

5

You just define a column with Integer type. SQLite sets the column length to 1,2,4,8 depending on your input.

answered May 06 '13 at 08:00

Shnkc

2,108
1
27
35

score 5 · Answer 5 · edited May 23 '17 at 12:26

5

His above link depicts a 64 bit Integer or Essentially a long, also see What is the difference between SQLite integer data types like int, integer, bigint, etc.?

and Version of SQLite used in Android?

edited May 23 '17 at 12:26

Community

1
1

answered Dec 29 '11 at 19:40

L7ColWinters

1,342
1
14
31

score 4 · Answer 6 · answered Apr 19 '15 at 08:26

4

SQLIte will set suitable integer width depend on your input

answered Apr 19 '15 at 08:26

DarkTemple

71
4

score 1 · Answer 7 · answered Nov 08 '19 at 10:27

the INTEGER can store the long but to get long from cursor should do like this :

int type = cursor.getType(j);

String value = cursor.getString(j);
try {
       int intValue = Integer.parseInt(value);
       field.set(object, intValue);
    } catch (NumberFormatException e) {
       long longValue = Long.parseLong(value);
       field.set(object, longValue);
}

i use this to store timestamp in sqlite

Is there type Long in SQLite?

7 Answers7

Linked