There is no hexadecimal number, it is always a hexadecimal string representation of a number :)
And in Java the default string representation of numbers is decimal, just run System.out.println(0xFF) to see it. If you need anything else, you have to convert you number into the needed string representation manually. Sergi 2016-09-07 12:17 GMT+03:00 Manuri Amaya Perera <[email protected]>: > 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]>: >> >>> 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. > -- 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.
