String to double issue in Java

Question

I am getting a strange problem while parsing a double from String of length greater than 7.

For example: The String contains the value:

String str = '123456789'

When I run the following code:

double d = Double.parseDouble(str);
System.out.println(d);

The output is:

1.23456789E8

The value stored in the database is:

123456789.0000000000000000

The data type of column is decimal(40,16)

And there is no exception generated. Please let me know how can I handle it.

Seems ok to me (except for the wrong quotes used to define the string), where do you see a problem? — Henry, Jan 26 '16 at 06:34
1.23456789E8 = 1.23456789 * 10^8 = 123456789 = 123456789.0000000000000000 - No problem there. — Florian Schaetz, Jan 26 '16 at 06:35
The problem is that I have to display the same value on my website and over there it shows 1.23456789E8 — Mehmood Memon, Jan 26 '16 at 06:35
Possible duplicate of [Convert double to String in Java](http://stackoverflow.com/questions/25067808/convert-double-to-string-in-java) — , Jan 26 '16 at 06:37

score 3 · Answer 1 · edited Jan 26 '16 at 06:38

3

1.23456789E8 is 1.23456789 x 10 ^8^, so the result looks as it should.

edited Jan 26 '16 at 06:38

Maytham Fahmi

answered Jan 26 '16 at 06:36

Yes but I want it to be displayed as it is stored in the database. – Mehmood Memon Jan 26 '16 at 06:38
1

look into things like DecimalFormat – Adrian Shum Jan 26 '16 at 06:38

score 2 · Answer 2 · answered Jan 26 '16 at 06:38

2

1.23456789E8 is in scientfic format and can be read as 1.23456789 * Math.pow(10,8)

To print in decimal format use:

System.out.printf("%f", d);

answered Jan 26 '16 at 06:38

Radu Ionescu

score 1 · Answer 3 · answered Jan 26 '16 at 06:38

1

To get a differently formatted output use for example

System.out.printf("%15.7f%n", d);

answered Jan 26 '16 at 06:38

Henry

score 1 · Answer 4 · edited May 23 '17 at 11:54

1

String str = "123456789";
double d = Double.parseDouble(str);
System.out.printf("%f\n", d);// print 123456789.000000

edited May 23 '17 at 11:54

Community

answered Jan 26 '16 at 06:49

mmuzahid

score 1 · Answer 5 · answered Jan 26 '16 at 07:23

1

Try this out, this will help you what you want.

new BigDecimal(d).toPlainString()

answered Jan 26 '16 at 07:23

Sindhoo Oad

Thanks. The output is fine now. – Mehmood Memon Jan 26 '16 at 07:30
This way of doing it will give you unexpected results for most non-integer values of `d`. To get your `double` looking the same as what's in your database, using `BigDecimal`, you'd be better to write `BigDecimal.valueOf(d).toPlainString()`. – Dawood ibn Kareem Jan 26 '16 at 10:13
@DavidWallace I appreciate that you want to make ans better, I havent tried that approach, if you are confirm then you can edit that ans, so that other can be beneficiary from it. – Sindhoo Oad Jan 27 '16 at 04:32

5 Answers5