Re: [sqlite] Affinity modes
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), and to repeat myself: > 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. Please read the whole posting in stead of just the subject. Jarl - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Affinity modes
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 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 could not link directly to that section. The feature I want most is of course "strict affinity". Jarl - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Affinity modes
"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 could not link directly to that section. The feature I want most is of course "strict affinity". Jarl - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] Affinity modes
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] -
Re: [sqlite] Affinity modes
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. The docs refer to a STRICT mode, saying that can be used to force an error if a wrong data type is used. The docs don't tell how to enable it, though. -- - stephan beal http://wanderinghorse.net/home/stephan/
Re: [sqlite] Affinity modes
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] -
[sqlite] Affinity modes
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] -