Which data type is suitable to insert larger numbers in SQLite. Can anybody please guide me? I want to insert numbers greater than 10 digits.

  • 1
    What kind of numbers? Integers? Or Decimals? How big can they be? – ypercubeᵀᴹ Jan 4 '16 at 14:39

The maximum INTEGER sqlite can store as a signed BIGINT is 9,223,372,036,854,775,807 (9 and a bit Quintillion), which is "greater than 10 digits".

SQLite Datatype Documentation.

The SQLite FAQ also covers an import aspect of dealing with data in SQLite - the fact it uses Dynamic Typing.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.