On Jun 29, 2009, at 3:13 AM, Wenton Thomas wrote:

> When executing   "pragma integrity_check" ,sqlite will return a   
> error message if  there exist something wrong
> with  the database file.
> Now I wonder  what's the max length of the error message?
> Is it possiable  that the length  exceeds  255?


It is easily possible if the database is badly corrupted.

You can limit the amount of error text returned by integrity_check by  
adding an argument.  For example:

     PRAGMA integrity_check(2);

Will return at most two database structure errors before it gives up  
and quits.   This is not a promise, but I do not think 2 errors are  
likely to exceed 255 characters in length.

D. Richard Hipp
d...@hwaci.com



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to