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. Jarl Friis <[EMAIL PROTECTED]> wrote: Hi. On SqliteWikiFaq [1] I see: Q) How can the strict affinity mode be used which is claimed to exist on http://www.sqlite.org/datatype3.html A) This has not been implemented as of version 3.3.13. Is this still the status as of version 3.5.1? Wouldn't it be an idea to remove section 6 "Other Affinity Modes" until this feature has been implemented, or at least on that page state that the feature is not implemented yet, and in what version it is expected to be implemented. See also http://www.mail-archive.com/sqlite-users%40sqlite.org/msg04358.html http://www.mail-archive.com/sqlite-users%40sqlite.org/msg09904.html http://www.mail-archive.com/sqlite-users%40sqlite.org/msg11085.html http://www.mail-archive.com/sqlite-users%40sqlite.org/msg13331.html Jarl [1] http://www.sqlite.org/cvstrac/wiki?p=SqliteWikiFaq ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------