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