Thing about MySQL is that the rounding is done when selected i think. So a float isn't stored 10, 6 but only SELECTED 10,6.
I'd say create a trigger ;) create trigger round_latlng before insert on markers STATEMENT. Triggers are fun ;) 2009/1/2 Barry Hunter <[email protected]> > > Depends on how you are storing them in mysql, if you are using a pair > of decimal(10,6) columns, then the rounding will happen anyway. > > But you mention 'geometry' which suggests you are looking at the > spatial extensions, which may well use a different system. > > But either way roudning to 6dp isnt really going to hurt - unless you > working to cm accuracy! - and doing the rounding will save you a bit > of bandwidth over the wire anyway. > > 2009/1/1 Alan C <[email protected]>: > > > > I am working on a project to store routes and associated information > > points. This is going onto a linux, apache, mysql, php equipped > > server. > > > > Using the examples I now have my input system working so routes and > > points can be converted into a series of coordinates. I noted that > > advice about storing points in mysql as 10,6 and so have gone to a lot > > of trouble to round all my points to 6 places in the clientside > > javascript before passing them to the server. My intention was to save > > space and processing time > > > > but . . . the mysql geometry documentation says coordinates are > > stored as double precision numbers > > > > so, my question is . . . have I wasted all that effort because mysql > > is going to store my rounded numbers as double precision anyway? > > > > > > > > > > > > > -- > Barry > > - www.nearby.org.uk - www.geograph.org.uk - > > > > -- Bjorn Brala ---------------- GeoStart.nl- Google maps - Swis Webdesign --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Google Maps API" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Google-Maps-API?hl=en -~----------~----~----~----~------~----~------~--~---
