It is possible to insert binary data in a script sql?

[Juan Pablo Gardella]

I 'm building some tests and I need to populate a table that have a binary data column. So I tried:

insert into Archivo
(id, file, fileName, fechaCreacion)
values
(1,0xff,'file1',CURRENT_TIMESTAMP());

But doesn't work. It is possible insert in a script binary data (to test purposes).

Thanks in advance
Juan

[Ryan How]

You could try a SCRIPT TO command on a database with binary data and see
how it is represented in the script.

> --
> You received this message because you are subscribed to the Google
> Groups "H2 Database" group.
> To post to this group, send email to h2-da...@googlegroups.com.
> To unsubscribe from this group, send email to
> h2-database...@googlegroups.com.
> For more options, visit this group at
> http://groups.google.com/group/h2-database?hl=en.

[Thomas Mueller]

Hi,

This is documented:

http://h2database.com/html/grammar.html#value

->

http://h2database.com/html/grammar.html#bytes

->

example: X'01FF'

You can also use:

    insert into Archivo (id, file, fileName, fechaCreacion) 

    values(1,'ff','file1',CURRENT_TIMESTAMP());

There is also a system function: http://h2database.com/html/functions.html#file_read

Regards,

Thomas

On Thu, Jul 26, 2012 at 12:11 PM, Ryan How <rh...@exemail.com.au> wrote:

You could try a SCRIPT TO command on a database with binary data and see how it is represented in the script.

On 26/07/2012 2:05 PM, Juan Pablo Gardella wrote:

I 'm building some tests and I need to populate a table that have a binary data column. So I tried:

insert into Archivo
(id, file, fileName, fechaCreacion)
values
(1,0xff,'file1',CURRENT_TIMESTAMP());

But doesn't work. It is possible insert in a script binary data (to test purposes).

Thanks in advance
Juan

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.

To unsubscribe from this group, send email to h2-database+unsubscribe@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.

--
You received this message because you are subscribed to the Google Groups "H2 Database" group.
To post to this group, send email to h2-da...@googlegroups.com.

To unsubscribe from this group, send email to h2-database+unsubscribe@googlegroups.com.

[Juan Pablo Gardella]

Thanks Thomas!! I will test that

Regards,
Juan

2012/8/15 Thomas Mueller <thomas.to...@gmail.com>

To unsubscribe from this group, send email to h2-database...@googlegroups.com.

[Juan Pablo Gardella]

Thanks, this works!!

2012/8/15 Juan Pablo Gardella <gardella...@gmail.com>