Re: [sqlite] How to select Strict Affinity or No Affinity modes?Attention: DRH

; Sent: Friday, February 08, 2008 11:52 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] How to select Strict Affinity or No Affinity > modes?Attention: DRH > > I would like to have strict affinity mode too. In our schemas we use > check constraints to en

Re: [sqlite] How to select Strict Affinity or No Affinity modes?Attention: DRH

: [sqlite] How to select Strict Affinity or No Affinity modes?Attention: DRH I would like to have strict affinity mode too. In our schemas we use check constraints to enforce strict affinity. Unless you're working in a dynamic typed environment, I can't imagine why you would want to have inconsistent

Re: [sqlite] How to select Strict Affinity or No Affinity modes? Attention: DRH

I would like to have strict affinity mode too. In our schemas we use check constraints to enforce strict affinity. Unless you're working in a dynamic typed environment, I can't imagine why you would want to have inconsistent data within a single database field. Also for consistency with

Re: [sqlite] How to select Strict Affinity or No Affinity modes? Attention: DRH

I second the strict affinity mode as an optional feature, for the same reasons as Lee. A while back I ran into a problem while using the bit and feature of sqlite and got unexpected results because sqlite changed the type from a 64bit integer into a real. (I think)... In this case it would

Re: [sqlite] How to select Strict Affinity or No Affinity modes? Attention: DRH

DRH, ">> Can you explain why you think strict affinity mode >> might be beneficial to you? If somebody can provide a good >> enough rational to justify strict affinity mode, we might just put it >> in." My response to your request for an example of a benefit is that I have always been an