So why can't you do like this: sql = "UPDATE table1 SET stringblob = X'" . bin2hex(...) . "' ...";
Pavel On Thu, Sep 10, 2009 at 4:01 PM, yogibabu <madra...@interia.pl> wrote: > > > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users