[SQL-CVS] r3467 - SQLObject/branches/0.9/docs
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: <sub...@co...> - 2008-05-26 15:09:31
|
Author: phd Date: 2008-05-26 09:09:23 -0600 (Mon, 26 May 2008) New Revision: 3467 Modified: SQLObject/branches/0.9/docs/SQLObject.txt Log: Added a note about type affinity in SQLite. Modified: SQLObject/branches/0.9/docs/SQLObject.txt =================================================================== --- SQLObject/branches/0.9/docs/SQLObject.txt 2008-05-23 12:33:55 UTC (rev 3466) +++ SQLObject/branches/0.9/docs/SQLObject.txt 2008-05-26 15:09:23 UTC (rev 3467) @@ -1097,11 +1097,15 @@ number of digits stored, and `precision` for the number of digits after the decimal point. WARNING: it may happen that DecimalCol values, although correctly - stored in the DB, are returned as floats instead of decimals. + stored in the DB, are returned as floats instead of decimals. For + example, due to the `type affinity`_ SQLite stores decimals as integers + or floats (NUMERIC storage class). You should test with your database adapter, and you should try importing the Decimal type and your DB adapter before importing SQLObject. +.. _`type affinity`: http://sqlite.org/datatype3.html#affinity + `EnumCol`: One of several string values -- give the possible strings as a list, with the `enumValues` keyword argument. MySQL has a native |