Argh I can't work this one out. It started with my currencies rounding to the nearest dollar but the plot thickens... My local copy works fine so I actually think this is a php set up issue or something. I have non-currency fields are rounding, i get no decimal places

decimal(2,2), currency and even currency(3,2) always come out as decimal(x,0) on my host!

e.g. Currency(3,0) outputs these when running db/build

# Field MenuItem.Price: changed to decimal(3) not null (from decimal(3,0) not null)
# Field MenuItem_Live.Price: changed to decimal(3) not null (from decimal(3,0) not null)
# Field MenuItem_versions.Price: changed to decimal(3) not null (from decimal(3,0) not null)

The MySQL expert at my hosting company had no idea. If the error is with Silverstripe where could I check it?

adding ?showqueries=1 to your will tell you what sql is being run, then you can try it from phpMyAdmin to see if the sql is correct.

?showqueries=1 didn't show me anything so perhaps this isn't how i'm supposed to use it.

Anyone??