On Apr 21, 2008, at 3:10 PM, Robert Bielik wrote: > Hi all, > > I'm using the sqlite3_blob_* api to write a larger text stream > incrementally. Works a charm, but is there a way to > change the datatype of the blob to text afterwards ? I'd like to see > the text easily in f.i. SQLiteSpy. >
Perhaps: SELECT CAST(b AS TEXT) FROM table Really I suppose it depends on what SQLiteSpy is using to determine that the column type is BLOB. If you can subversion that mechanism into thinking the column type is TEXT, then it should just work. D. Richard Hipp [EMAIL PROTECTED] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
