Dan wrote: > So in SQLLite, what happens of you try to store XYZ in an integer field?
Without your having enabled any of the "affinity" options mentioned by Dave Cook, SQLite will happily store 'XYZ' in that column, and return it to you when you query that row. The types are either ignored, or advisory, or meaningful in various ways, depending on the settings you pick. Note that this is considered something as a desirable feature in the SQLite community, in a similar fashion (it appears to me) to how dynamic typing is considered in the Python community, so don't consider it outright to be a Bad Thing. I'd say more on the issue, if I knew anything that I hadn't just read in the documentation. ;-) -Peter -- http://mail.python.org/mailman/listinfo/python-list