Last activity: 2 May 2017 23:55 EDT
Maximum length of Decimal
I have problem that I can't insert or save a record with 10 digit or 1 billion in Decimal Data Type. How to resolve this? Is there any Numeric Data Type that have more than 10 Digit? I'm using DECIMAL in my Data Type.
Here is my ERROR log
DatabaseException caused by prior exception: org.postgresql.util.PSQLException: ERROR: numeric field overflow
Detail: A field with precision 18, scale 9 must round to an absolute value less than 10^9.
| SQL Code: 0 | SQL State: 22003
Thanks in Advance.