Pavel Ivanov-2 wrote:
> 
> I don't really understand what you're trying to achieve, but what about
> 
> UPDATE table1 SET stringblob = cast(hex(string) as blob) ....
> 

thanks i'm somewhat closer to what i want to do, but how to insert to a blob
a hex speak like "deadbeef" in a way that it will be stored as I entered it

what I want do do is to put a binary string encoded with php function
bin2hex into blob

for example if I do cast('deadbeef' as blob) the result is 64 65 61 64...
etc... and I want it to be DE AD BE EF
-- 
View this message in context: 
http://www.nabble.com/how-to-pass-function-result-to-a-blob---tp25389627p25390053.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

Reply via email to