BigDecimal, precision and scale

by

A BigDecimal is defined by two values: an arbitrary precision integer and a 32-bit integer scale. The value of the BigDecimal is defined to be unscaledValue*10^{-scale}.

Precision:

The precision is the number of digits in the unscaled value.
For instance, for the number 123.45, the precision returned is 5.

So, precision indicates the length of the arbitrary precision integer. Here are a few examples of numbers with the same scale, but different precision:

  • 12345 / 100000 = 0.12345 // scale = 5, precision = 5
  • 12340 / 100000 = 0.1234 // scale = 4, precision = 4
  • 1 / 100000 = 0.00001 // scale = 5, precision = 1

In the special case that the number is equal to zero (i.e. 0.000), the precision is always 1.

Scale:

If zero or positive, the scale is the number of digits to the right of the decimal point. If negative, the unscaled value of the number is multiplied by ten to the power of the negation of the scale. For example, a scale of -3 means the unscaled value is multiplied by 1000.

This means that the integer value of the ‘BigDecimal’ is multiplied by 10^{-scale}.

Here are a few examples of the same precision, with different scales:

  • 12345 with scale 5 = 0.12345
  • 12345 with scale 4 = 1.2345
  • …
  • 12345 with scale 0 = 12345
  • 12345 with scale -1 = 123450 †

BigDecimal.toString:

The toString method for a BigDecimal behaves differently based on the scale and precision. (Thanks to @RudyVelthuis for pointing this out.)

  • If scale == 0, the integer is just printed out, as-is.
  • If scale < 0, E-Notation is always used (e.g. 5 scale -1 produces “5E+1”)
  • If scale >= 0 and precision - scale -1 >= -6 a plain decimal number is produced (e.g. 10000000 scale 1 produces “1000000.0”)
  • Otherwise, E-notation is used, e.g. 10 scale 8 produces “1.0E-7” since precision - scale -1 equals unscaledValue*10^{-scale} is less than -6.

More examples:

  • 19/100 = 0.19 // integer=19, scale=2, precision=2
  • 1/1000 = 0.0001 // integer=1, scale = 4, precision = 1

More Related Contents:

  1. Java BigDecimal trigonometric methods
  2. ArithmeticException thrown during BigDecimal.divide
  3. How to display a number with always 2 decimal points using BigDecimal?
  4. Double vs. BigDecimal?
  5. How to change the decimal separator of DecimalFormat from comma to dot/point?
  6. How to return a custom object from a Spring Data JPA GROUP BY query
  7. Mapping PostgreSQL JSON column to a Hibernate entity property
  8. Connection to Db dies after >4
  9. How to choose the id generation strategy when using JPA and Hibernate
  10. How to view the SQL queries issued by JPA?
  11. Hibernate, @SequenceGenerator and allocationSize
  12. How to set thousands separator in Java?
  13. “detached entity passed to persist error” with JPA/EJB code
  14. Spring Data JPA – “No Property Found for Type” Exception
  15. JPA/Hibernate Native Queries do not recognize Parameters
  16. What is the easiest way to ignore a JPA field during persistence?
  17. Convert seconds value to hours minutes seconds?
  18. BigDecimal – to use new or valueOf
  19. Single DAO & generic CRUD methods (JPA/Hibernate + Spring)
  20. Changing Persistence Unit dynamically – JPA
  21. Change database schema during runtime based on logged in user
  22. Removing trailing zeros from BigDecimal in Java
  23. Loss of precision – int -> float or double
  24. Java Enums, JPA and Postgres enums – How do I make them work together?
  25. How to map sql native query result into DTO in spring jpa repository?
  26. Difference between a “jta-datasource” and a ” resource-local ” datasource?
  27. java.lang.NoSuchMethodError: javax.persistence.spi.PersistenceUnitInfo.getValidationMode()Ljavax/persistence/ValidationMode;
  28. Batch inserts with JPA/EJB3
  29. database sort vs. programmatic java sort
  30. JPA Criteria Tutorial [closed]

Leave a Comment