On 10 Jan 2020, at 3:11pm, Ryan Mack <ryan.m...@gmail.com> wrote: > OK, I think I've got a better sense now. Hex encoding the column shows that > there's actually a huge amount of data stored in there. For some reason > length() isn't revealing it even if the column type is blob. Dumping and > restoring the table is truncating the data.
Is there a chance that some part of the software thinks that 0x00 is a terminator for BLOBs, and some other part ignores the 0x00 and abides strictly by the length ? I've seen that before. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users