liran ritkop <rejt...@bgu.ac.il> wrote: > So.. It's not possible to change the size of the blob field?
It's possible with an UPDATE statement, but it's expensive. You can't just append to an existing blob, you have to provide all of the blob's data, old and new. You might be better off storing the data in separate files, and just using SQLite to maintain metadata, like timestamps. > I have different problem related to this subject: > i wrote some code that put blob data (i declared a string and pass it with > (char*) to the buffer i send to the blob). > The problem is that it takes only 32 bytes of that string.. what with the > rest of the string? why does it cut it? How exactly do you bind that string? Show some code. My guess is, you tell SQLite to treat it as NUL-terminated string (rather than specifying its length explicitly), and there's a zero byte in your data at offset 32. -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
