diff options
| author | Claude Paroz <claude@2xlibre.net> | 2019-09-08 23:25:53 +0200 |
|---|---|---|
| committer | Mariusz Felisiak <felisiak.mariusz@gmail.com> | 2019-09-14 17:10:08 +0200 |
| commit | b8dff52f440adfb78b40e19ee8bff45373ca2501 (patch) | |
| tree | 41a15b1629615bfcbe3a46055317da3c76bc9d63 | |
| parent | 4056558a1c9cf650ab6e7cb1a319206d2e8c770f (diff) | |
| download | django-b8dff52f440adfb78b40e19ee8bff45373ca2501.tar.gz | |
Fixed #29823 -- Doc'd limitation of DecimalField on SQLite.
| -rw-r--r-- | docs/ref/databases.txt | 12 | ||||
| -rw-r--r-- | docs/ref/models/fields.txt | 4 |
2 files changed, 15 insertions, 1 deletions
diff --git a/docs/ref/databases.txt b/docs/ref/databases.txt index 1d11112d79..d0eed1ecc4 100644 --- a/docs/ref/databases.txt +++ b/docs/ref/databases.txt @@ -677,6 +677,18 @@ substring filtering. .. _documented at sqlite.org: https://www.sqlite.org/faq.html#q18 +.. _sqlite-decimal-handling: + +Decimal handling +---------------- + +SQLite has no real decimal internal type. Decimal values are internally +converted to the ``REAL`` data type (8-byte IEEE floating point number), as +explained in the `SQLite datatypes documentation`__, so they don't support +correctly-rounded decimal floating point arithmetic. + +__ https://www.sqlite.org/datatype3.html#storage_classes_and_datatypes + "Database is locked" errors --------------------------- diff --git a/docs/ref/models/fields.txt b/docs/ref/models/fields.txt index b6afd23dc2..ac21380db2 100644 --- a/docs/ref/models/fields.txt +++ b/docs/ref/models/fields.txt @@ -715,7 +715,9 @@ when :attr:`~django.forms.Field.localize` is ``False`` or For more information about the differences between the :class:`FloatField` and :class:`DecimalField` classes, please - see :ref:`FloatField vs. DecimalField <floatfield_vs_decimalfield>`. + see :ref:`FloatField vs. DecimalField <floatfield_vs_decimalfield>`. You + should also be aware of :ref:`SQLite limitations <sqlite-decimal-handling>` + of decimal fields. ``DurationField`` ----------------- |