Page 1 of 1

decimal places is mysql

Posted: Thu Jul 28, 2011 9:53 pm
by jonathon
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

Re: decimal places is mysql

Posted: Fri Jul 29, 2011 6:52 am
by bowersbros
try float(7,5)

Re: decimal places is mysql

Posted: Fri Jul 29, 2011 2:59 pm
by jonathon
How silly :oops:

Thanks :)