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 <[email protected]> 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 [email protected]. >> To unsubscribe from this group, send email to h2-database+unsubscribe@** >> googlegroups.com <h2-database%[email protected]>. >> For more options, visit this group at http://groups.google.com/** >> group/h2-database?hl=en<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 [email protected]. > To unsubscribe from this group, send email to h2-database+unsubscribe@** > googlegroups.com <h2-database%[email protected]>. > For more options, visit this group at http://groups.google.com/** > group/h2-database?hl=en <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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
