Ive got a mysql database field and i wanna set it to decimal 10,2 but it wont let me, it keeps changing it back to 10,0 and i want to import from an access database a table that has a couple of fields of currency values with 2 decimal places. How can i import these currency values into mysql without it rounding off the figures to whole dollars? currently after i import them it rounds them off and i cant work out how to stop the rounding. I also have to use this field for calculations later on so i need decimals.
later..
later..