decimal places is mysql
Posted: Thu Jul 28, 2011 9:53 pm
Hello
I'm inserting some data from a CSV and loading the file through MYSQL. Which works fine, but i have some longitude and latitude values with 5 decimal places, but every time I insert the file, the decimal places get stripped to 2 decimal places. I've been through my CSV and formatted all the decimal places to 5 and i specified the columns as both float (7,2) and decimal (7,2) and neither of them have worked. Am I missin g something :S
Thanks in advance
I'm inserting some data from a CSV and loading the file through MYSQL. Which works fine, but i have some longitude and latitude values with 5 decimal places, but every time I insert the file, the decimal places get stripped to 2 decimal places. I've been through my CSV and formatted all the decimal places to 5 and i specified the columns as both float (7,2) and decimal (7,2) and neither of them have worked. Am I missin g something :S
Thanks in advance