Here are two links that explain that you need to be careful on decimal
columns when using mysql on the target platform.  sqlite3 is a little
more forgiving.

http://scottmotte.com/archives/86.html
http://blog.coryfoy.com/2008/06/problems-in-rails-between-development-and-test-databases/

I sorted my problem out by running:

rake RAILS_ENV=staging db:drop
rake RAILS_ENV=staging db:create
rake RAILS_ENV=staging db:migrate

I am sure that I did this ......... but it could have been very late!

So in a nutshell, use a scale and precision on decimal if you intend
your target dbms to be mysql.

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 [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/rubyonrails-talk?hl=en.

Reply via email to