[SQL-CVS] r3469 - SQLObject/trunk/docs

[<sub...@co...>]

Author: phd
Date: 2008-05-26 09:11:07 -0600 (Mon, 26 May 2008)
New Revision: 3469

Modified:
   SQLObject/trunk/docs/SQLObject.txt
Log:
Added a note about type affinity in SQLite.

Modified: SQLObject/trunk/docs/SQLObject.txt
===================================================================
--- SQLObject/trunk/docs/SQLObject.txt	2008-05-26 15:10:16 UTC (rev 3468)
+++ SQLObject/trunk/docs/SQLObject.txt	2008-05-26 15:11:07 UTC (rev 3469)
@@ -1126,11 +1126,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