I have two fields on the Location table called latitude and Longitude- both are floating point number fields.
By default the system allows up to 7 digits after the decimal point. if we are giving more than 7 digits value is rounding off.
But I would need to store the coordinated with 15 digits after the decimal point, and also need 4 digits before the decimal point. (including the '+', '-' sign)
Example latitude : -90.897845651232145
longitude: -180.321232126545987.
How can I modify these fields to store such high-precision floating values without rounding or truncation?
Could anyone please help me to achieve.
And one more thing I would like to tell you on the latitude field I turned on to advance view and on the attributes I gave scale=15 and maximum length I updated to 50. now it's taking 13 digits after decimal but if we are giving more than 13 digits then the value is truncating.
could anyone help me with the logic.
