Ive got tables that store geo location data as type 'Geometry' Ive done a mysql dump and loaded the same database onto my local server.
Now when running the exact same query on both servers Im getting different results. The query converts the geo raw data to proper lat and lng results.
On the live server I get something like : '-33.914937875882' (perfect)
On the local server I get something like : '-1.02164062238311e-49'
That's a totaly different number and there is a 'e-49' at the end of it?
- The original data is the same on both servers.
- The local server is a mac and live is linux.
- Both tables are utf8
- Different versions of mysql on each server