Duncan Booth <duncan.bo...@invalid.invalid> wrote: >Tim Roberts <t...@probo.com> wrote: > >>>However, when it comes to writing-back data to the table, SQLite is >>>very forgiving and is quite happy to store '25/06/2003' in a date >>>field, >> >> SQLite is essentially typeless. ALL fields are stored as strings, >> with no interpretation. You can store whatever you want in any >> column. The column types are basically there to remind YOU how to >> handle the data. > >Not all fields are stored as strings; they may also be stored as >integer, floating point values or binary data.
Sorry. Up through SQLite version 2, ALL fields were stored as strings, even if you typed them as integers or floats. I see that has changed in v3. -- Tim Roberts, t...@probo.com Providenza & Boekelheide, Inc. -- http://mail.python.org/mailman/listinfo/python-list
