On Thu, Jul 08, 2010 at 02:27:02PM +0100, Andrew Wood scratched on the wall:
> Even if I fix the way a blob is inserted so that it causes it to be > correctly detected as a blob by sqlite3_column_type() theres still a > problem - because if a field comes back as SQLITE_NULL my application > still needs to know what type the field was supposed to be. Most applications know what they asked for, but I realize there are some that do not (like GUI database managers). Still, if you have a NULL, what are you going to do about it? If you know a column should have BLOBs in it, you can also just keep asking for BLOBs. SQLite will covert them using the rules defined here: http://sqlite.org/c3ref/column_blob.html -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
