Re: [sqlite] Strict affinity again

* D. Richard Hipp: > SQLite is strongly typed, Curiously, it's even more strongly typed than SQL: sqlite> SELECT 1 = '1'; 0 fw=> SELECT 1 = '1'; ?column? -- t (1 row) (In SQL, quoted values are not of string type, but their type is inferred from context.)

Re: [sqlite] Strict affinity again

On Wed, 25 Mar 2009 13:06:24 -0400, "Wilson, Ron P" wrote: >Cool! I didn't think of doing that. >I presume this would incur a performance hit >on insert/update to check the constraint Not much. The column data is _dynamically_ typed, so SQLite will

Re: [sqlite] Strict affinity again

I'd be willing to bet that amongst experienced SQLite users, you're in the minority. More importantly, I don't think Dr. Hipp agrees with you, so the discussion is very likely moot. :) -T On Wed, Mar 25, 2009 at 9:02 AM, wrote: > Hi everyone, > >

Re: [sqlite] Strict affinity again

On Mar 25, 2009, at 9:02 AM, sqlite.20.tomca...@spamgourmet.com wrote: > Hi everyone, > > I'm new to sqlite and this mailing list and hope to get some help > here. I've used SQLite for some projects now and I must say, that it > is the fastes database I ever used. Great work! > > But there is

[sqlite] Strict affinity again

Hi everyone, I'm new to sqlite and this mailing list and hope to get some help here. I've used SQLite for some projects now and I must say, that it is the fastes database I ever used. Great work! But there is one thing, that I really dislike, because I get errors sometimes with this and that is