0

I need to know what is the max size of NSData that can be inserted in one row of an SQLite database => a max size of a column as opposed to the max size of a whole SQLite database.

Eric Aya
  • 69,473
  • 35
  • 181
  • 253
issam
  • 697
  • 1
  • 9
  • 15
  • i need to know for just one row Anbu-karthik, not the max size of file data or the all data – issam Aug 04 '16 at 10:17
  • IMO it is a new question - a maximum column size as opposed to maximum database size. The answer is - per default 1,000,000,000 bytes, SQLite can be recompiled to support 2,147,483,647 bytes. You can find it in https://www.sqlite.org/limits.html. – Tomasz Stanczak Aug 04 '16 at 11:55

1 Answers1

0

A maximum column size as opposed to maximum database size per default 1,000,000,000 bytes, SQLite can be recompiled to support 2,147,483,647 bytes. You can find it in Limits in SQLite

Tomasz Stanczak
  • 12,796
  • 1
  • 30
  • 32