Hi Sjoerd,Thank you for this is makes sense now.However essentially to INSERT data into a BLOB you are going to have convert the data before inserting it into database, which could be expensive in compute time.Regards,Brian HoodOn Mon, Jun 26, 2017 at 9:19 AM, Sjoerd Mullender <sjoerd@acm.org> wrote:> ______________________________On 24/06/17 21:31, Brian Hood wrote:
> Hi Guys,
>
> I don't seem to be able to INSERT into a blob field is there any
> information how to achieve this.
>
> Regards,
>
> Brian Hood
_________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>
Normally that would be something like:
INSERT INTO t VALUES ('0102030405060708090a0b0c0d0e0f');
where the value being inserted is no more than a list of hexadecimal
digits with en even length (two digits per octet).
--
Sjoerd Mullender
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list