I am storing image as BLOB in sqlite database. Can anyone please tell me the Maximum size for the image to be stored as BLOB in sqlite database .
3 Answers
As of September 2020: 2.15GB
https://www.sqlite.org/limits.html
current implementation will only support a string or BLOB length up to 231-1 or 2147483647
Workarounds:
- Compress your file.
- Split your file by column.
- Split your file by rows.
- Use multiple blob fields.
Related