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