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
