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]>: > 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]. > 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. > -- 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.
