Hi, The function UTF8TOSTRING should help: http://h2database.com/html/functions.html#utf8tostring
Regards, Thomas On Sun, Jun 9, 2013 at 5:09 PM, Pierre <[email protected]> wrote: > Hello, > > How to display varbinary field in text format in the h2 console ? > > It displays the varbinary field with hex representation, so I tryied > cast(field as varchar) and convert(field,varchar) but it keep displaying > varbinary in hex format. > > How to display it like it was a String ? Thx > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database?hl=en-US. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database?hl=en-US. For more options, visit https://groups.google.com/groups/opt_out.
