CODEWITHSUNDEEP
sqlsqlite
chirag7jain
chirag7jain

Reputation: 1547

SQLite DataType Field Size

Does SQLite require you to mention field size or are there fixed size for each DataType

ID INTEGER (10)

ID INTEGER

Upvotes: 6

Views: 8279

Answers (2)

Pratibha
Pratibha

Reputation: 1786

each datatype have fixed size. for more details check http://www.sqlite.org/datatype3.html

Upvotes: 3

mvp
mvp

Reputation: 116477

SQLite will accept SQL dumps from most other databases, including INTEGER(10).

However, on import any column that has INT in its type will be considered INTEGER and will occupy 1, 2, 3, 4, 6, or 8 bytes depending on actual value.

Upvotes: 2

Related Questions