SQLite Forum

General question concerning database stucture and number of databases to use.
Login
Mutatis Mutandis TEXT fields which can also be larger than a page.  

There is no difference between CLOB (TEXT) and BLOB other than the overloading of type information, and the same issues apply to both (or to any record that is longer than the payload size of a page).

It does not matter whether the field is a 2 GB movie or a 2 GB novel written in ASCII prose.  What matters it the size.