On 11/4/07, Ken <[EMAIL PROTECTED]> wrote: > In order to maximize compatibility between SQLite and other database > engines, SQLite support the concept of "type affinity" on columns. The type > affinity of a column is the recommended type for data stored in that column. > The key here is that the type is recommended, not required. Any column can > still store any type of data, in theory. It is just that some columns, given > the choice, will prefer to use one storage class over another. The preferred > storage class for a column is called its "affinity".
> Seems pretty specific and explanatory to me. He's referring to section 6 of http://www.sqlite.org/datatype3.html which says otherwise. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------