SQLite3 Decimal Precision and Scale

Decimal precision and scale are not working:
45.50 becomes 45.5
50.358329384 will stay 50.358329384

Why?
—
Following the book, the decimal precision and scale that is added in a migration (p82) doesn’t work. When creating or updating entries, decimals aren’t following their precision or scale.

It may not be a problem with the book, but it would be nice to clear this up as we’re following along.

Does anyone know why this is happening?
—
Luke

I have encountered the same issue.

SQLITE3 doesn’t appear to actually support precision and scale in decimal values.

At the very least, the adapter is silently dropping them.

Here’s a page on sqlite3’s data type mangling.

http://www.sqlite.org/datatype3.html