Thank you, that's exactly what I was looking for, even if I have some varbin iso encoded, it's just a quick hack so I can use the h2 web interface until I have made my UI.
Nothing to do with this topic but I also discovered the AUTO_SERVER mode which is really great, I can use the h2 web interface to access my main application embbeded DB, that's a very cool feature. Le dimanche 9 juin 2013 18:18:26 UTC+2, Thomas Mueller a écrit : > > 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] > <javascript:>>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] <javascript:>. >> To post to this group, send email to [email protected]<javascript:> >> . >> 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.
