Re: MonetDB Blob Inserts

Hi Sjoerd, Does MonetDB support BINARY BULK LOAD into a blob column? And if not, is there a reason? Thanks, Anton On Sat, Jul 8, 2017 at 9:02 PM, Brian Hood wrote:

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 Hood

On Mon, Jun 26, 2017 at 9:19 AM, Sjoerd Mullender 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