• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

big binary number to decimal

 
Viral Thakkar
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello All,

I have a requirement to convert a big binary number (as input to me in form of String) to a decimal number and then persist this decimal number in Number(38) data type column of oracle database table.

Please suggest as which data type I should be using to hold this big decimal number and how to convert this binary representation string data to decimal number.

Thanks.
 
Keith Lynn
Ranch Hand
Posts: 2409
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Look at the API for java.math.BigInteger.
 
Edwin Dalorzo
Ranch Hand
Posts: 961
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Have you taken a look at the API about java.math.BigDecimal?
 
Viral Thakkar
Ranch Hand
Posts: 33
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks.

Solution:

BigInteger bigInt = new BigInteger("100010001000100010001000100010011000011100010001000100010001000100010011000011111111111111111111111111111111111111111111111100",2);

BigDecimal bigDec = new BigDecimal(bigInt);

Then use this BigDecimal object to persist the data in Number type in oracle database table.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic