On 7/28/16, Richard Hipp <[email protected]> wrote: > On 7/28/16, 이영준 <[email protected]> wrote: >> The title ["string or blob too big" issue on a corrupted db] may not >> clear >> for you. >> Let me describe my situation. >> >> I have a problematic database. >> It has two of tables which have a huge entry approximately 1.45GB. >> They are sqlite_sequence and log table. > > The default setting for SQLITE_LIMIT_LENGTH is 1GB. You will probably > need to raise that limit to 1.5GB before attempting to read the 1.45GB > entry.
I forgot an important detail: The SQLITE_LIMIT_LENGTH has a hard compile-time limit set by SQLITE_MAX_LENGTH that defaults to 1GB. So you will need to recompile with -DSQLITE_MAX_LENGTH=2000000000 in order to be able to raise the run-time limit. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
