Rails 3 and saving decimal values from a form

I have an odd bug in one of my applications. When I am using the sqlite3 database the bug is not present. However when I use mysql2 as the database adapter I run into an error saving decimal values from a form. If I submit the value 19.99 my input after the decimal is removed and it is stored in the database as 19.00

What would cause this? The database has the correct settings for the column and I can create a correct record using the rails console.

I have an odd bug in one of my applications. When I am using the sqlite3 database the bug is not present. However when I use mysql2 as the database adapter I run into an error saving decimal values from a form. If I submit the value 19.99 my input after the decimal is removed and it is stored in the database as 19.00

What would cause this? The database has the correct settings for the column and I can create a correct record using the rails console.

What does your migration file, model and code you are creating the record look like? You need to provide something that the group can use as a reproducible test case so we can help you.

B.

What would cause this? The database has the correct settings for the column and I can create a correct record using the rails console.

The only column type that works is "decimal" is that your case?

And gimme a link to your app so that I'll make it crash by inputting decimal values that have a comma :wink:

I had to go through this pain for my http://suivauto.com website that uses the French "," instead of the "." for decimal points.

What would cause this? The database has the correct settings for the

column and I can create a correct record using the rails console.

The only column type that works is “decimal” is that your case?

And gimme a link to your app so that I’ll make it crash by inputting

decimal values that have a comma :wink:

I had to go through this pain for my http://suivauto.com website that

uses the French “,” instead of the “.” for decimal points.

To be sure, in your migration you have the precision and scale for the column?

t.decimal “amount”, :precision => 10, :scale => 2