Duncan Booth <[email protected]> wrote: >Tim Roberts <[email protected]> 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, [email protected] Providenza & Boekelheide, Inc. -- http://mail.python.org/mailman/listinfo/python-list
