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.
1.23456789E8 is 1.23456789 x 10 ^8^, so the result looks as it should.
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);
To get a differently formatted output use for example
System.out.printf("%15.7f%n", d);
Try this out, this will help you what you want.
new BigDecimal(d).toPlainString()
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().
String str = "123456789";
double d = Double.parseDouble(str);
System.out.printf("%f\n", d);// print 123456789.000000
See also How to print double value without scientific notation using Java?
