I posted this yesterday but it was a bit long-winded: http://groups.google.com/group/rubyonrails-talk/browse_thread/thread/9a6db7467a16911e
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" decimal(8,2) mysql column definition from mysqldump: `amount` decimal(10,0) default NULL 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? O. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-t...@googlegroups.com. To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.