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

Reply via email to