[SQL-CVS] r3467 - SQLObject/branches/0.9/docs

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

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