Re: [sqlite] Affinity modes

2007-11-05 Thread Jarl Friis
Ken <[EMAIL PROTECTED]> writes: > 1. (*) text/plain > > Per your wiki link: > > 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. Yes I read that (I referenced it)

Re: [sqlite] Affinity modes

2007-11-05 Thread Ken
Per your wiki link: 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. Jarl Friis <[EMAIL PROTECTED]> wrote: "Trevor Talbot" writes: > On 11/4/07, Ken wrote: > > He's referri

Re: [sqlite] Affinity modes

2007-11-05 Thread Jarl Friis
"Trevor Talbot" <[EMAIL PROTECTED]> writes: > On 11/4/07, Ken <[EMAIL PROTECTED]> wrote: > > He's referring to section 6 of http://www.sqlite.org/datatype3.html > which says otherwise. Yes, section 6: mentioning "strict affinity" mode and "no affinity" mode. Unfortunately there was no tag, so I

Re: [sqlite] Affinity modes

2007-11-04 Thread Trevor Talbot
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

Re: [sqlite] Affinity modes

2007-11-04 Thread Stephan Beal
On 11/5/07, Ken <[EMAIL PROTECTED]> wrote: > > ...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. I think the OP was referring specifically to STRICT mode. T

Re: [sqlite] Affinity modes

2007-11-04 Thread Ken
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

[sqlite] Affinity modes

2007-11-03 Thread Jarl Friis
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 Aff