I have an attribute of a table named ad Latitude, i have set its
data type as
decimal(9,8) null but when i try to insert the value
33.42922222 it gives me the error
Parameter value '33.42922222' is out of range.
when i try to directly enter the value in the database table it gives the
Arithmetic overflow error
i have tried to change the datatype to
numeric(9,8) null but to no avail
please help me find out the problem ...
DECIMAL(9,8) is 1 digit before the decimal point and 8 digits after the decimal point.
DECIMAL(10,8) should work for