Thanks Thomas!! I will test that Regards, Juan
2012/8/15 Thomas Mueller <[email protected]> > 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. > -- 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.
