I posted this yesterday but it was a bit long-winded:
Here is a more succinct version.
Migration generates decimal(8,2) column type ok on sqlite but
decimal(10,0) on mysql. So I lose pence and cents on mysql!
The migration: t.decimal :amount, :precision => 8, :scale => 2
sqlite column definition from using .scheme table_name: “amount”
mysql column definition from mysqldump:
I have another table where it works ok on some columns and not on
others. See OP.
mysql (Ver 5.0.67), sqllite (v 3.6.12), Rails 2.3.5
Anyone have any ideas?