I save the Lat and Long values in the GEOMETRY type in MySql. Unfortunately, it seems to round up to 4 decimal places, which according to the Wikipedia article is not very accurate. I want to use the Geospatial functions in mySql, but it seems to me that I lack precision. Any ideas what I can do? Can I increase the accuracy, or am I forced to store it as a double / float? If I want to use any other function in the GIS part of mySql, will these values be rounded (even if I keep separate fields as another data type)?
source
share