Hi Sergi, I don't think both ways would work because, the purpose it self is to have it as a number(Hexa decimal). The result I get from h2 database shouldn't be of String type.
Thanks, Manuri On Wednesday, September 7, 2016 at 2:39:11 PM UTC+5:30, Sergi Vladykin wrote: > > Use VARCHAR and store String instead of numeric types. > Another way is to create SQL function that will format you number to > hexadecimal string and use it when you retrieve the data. > > Sergi > > 2016-09-07 10:26 GMT+03:00 Manuri Amaya Perera <[email protected] > <javascript:>>: > >> Hi all, >> >> I need to store Hexa Decimal characters in H2 and retrieve in the same >> format. But when I store a hexa decimal character and retrieve it, it is >> converted to decimal. >> >> For example if I store 0xb what is stored is 11 which is the decimal >> equivalent of it. >> >> Is there a way to avoid this and get the Hexa decimal value as it is. >> >> I'm using the H2 version 1.3.175. >> >> Thank you, >> Manuri >> >> -- >> 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 https://groups.google.com/group/h2-database. >> For more options, visit https://groups.google.com/d/optout. >> > > -- 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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
