I don't really understand what you're trying to achieve, but what about UPDATE table1 SET stringblob = cast(hex(string) as blob) ....
Pavel On Thu, Sep 10, 2009 at 3:34 PM, yogibabu <madra...@interia.pl> wrote: > > table has two three columns: > > i want to be able to put a result of internal sqlite3 function to a blob > > UPDATE table1 SET stringblob = hex(string) .... etc... > > but as a result of this query the "stringblob" column is populated by > text's, not by blobs > > something like this should work but it doesn't: > > UPDATE table1 SET stringblob = X'hex(string)' .... etc... > > it returns: unrecognized token x'hex', but when I put a variable by hand it > works ok > > id | string | stringblob > ---------------------------------- > 1 | 33 | 33 33 > -- > View this message in context: > http://www.nabble.com/how-to-pass-function-result-to-a-blob---tp25389627p25389627.html > Sent from the SQLite mailing list archive at Nabble.com. > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users