What is the maximum size of an image to be stored as a blob in sqlite database?

Question

I store the image as a blob in the sqlite database. Can someone tell me the maximum size for an image to be stored as a BLOB in the sqlite database.

Answer 1

See SQLite Limitations

The maximum number of bytes per row or BLOB in SQLite is determined by the SQLITE_MAX_LENGTH preprocessor macro. The default value of this macro is 1 billion (1 thousand million or 1,000,000,000).

This is roughly equivalent to 1 GB.

Answer 2

The maximum size of data to be stored in the BLOB can reach 2.1 GB in the sqlite database.