Re: [sqlite] Is sqlite case-sensitive?

At 22:36 18/05/2014, you wrote: The more I think of it, though, I think that the solution is as simple as converting all letters to lower(/upper) case and converting all whitespace to a single space each, except for within matching [ ], " ", ' ' or ` `. After that, I can do a memcmp().

Re: [sqlite] Very slow when query max(col) on empty set?

On Friday, 9 May 2014, RSmith wrote: > > On 2014/05/08 18:16, Woody Wu wrote: > >> On 2014年5月8日 GMT+08:00PM11:59:33, RSmith wrote: >> >>> On 2014/05/08 14:13, Woody Wu wrote: >>> Do you mean that my index for this case is already the best choice?

Re: [sqlite] Is sqlite case-sensitive?

On Sun, May 18, 2014 at 10:46 PM, James K. Lowden wrote: > On Sun, 18 May 2014 19:15:18 +0200 > RSmith wrote: > > > > As Igor says, http://sqlite.org/c3ref/prepare.html would be > > > appropriate. However, a database connection is required for this.

Re: [sqlite] Is sqlite case-sensitive?

On Sun, 18 May 2014 19:15:18 +0200 RSmith wrote: > > As Igor says, http://sqlite.org/c3ref/prepare.html would be > > appropriate. However, a database connection is required for this. > > But of course What kind of syntactical correctness can you hope > to check without

Re: [sqlite] Is sqlite case-sensitive?

On 2014/05/18 19:28, Wolfgang Enzinger wrote: Completely agreed. I was just referring to the OP who asked for an "API Indeed - my apologies too - I took your statement to imply that the solution (which Igor and yourself discussed) would not work for the OP precisely because of it needing

Re: [sqlite] Is sqlite case-sensitive?

Am Sun, 18 May 2014 19:15:18 +0200 schrieb RSmith: > But of course What kind of syntactical correctness can you hope to > check without a connection? [...] Completely agreed. I was just referring to the OP who asked for an "API to validate a SQL statement, either in the context of the

Re: [sqlite] Is sqlite case-sensitive?

On 2014/05/18 17:24, Wolfgang Enzinger wrote: i _think_ what you want is: http://sqlite.org/c3ref/complete.html I don't think so, because this function essentially checks "if [the statement] ends with a semicolon token". Furthermore, "these routines do not parse the SQL statements thus will

Re: [sqlite] Is sqlite case-sensitive?

>>> names), or without context (just validate syntax, e.g. that it can be >>> parsed)? >>> >> I am asking about this API since I think I remember seeing it once, but >> can't find it now >> > > i _think_ what you want is: > > http://sqlite.org/c3ref/complete.html I don't think so, because this

Re: [sqlite] Is sqlite case-sensitive?

On 18 May 2014, at 3:32pm, Baruch Burstein wrote: > Sqlite is case-insensitive as far as table/column/db names. Is this > documented as official behavior or it may change? I would like to expand the scope of this question because I think an answer to just what Baruch

Re: [sqlite] Is sqlite case-sensitive?

On 5/18/2014 10:32 AM, Baruch Burstein wrote: Sqlite is case-insensitive as far as table/column/db names. Is this documented as official behavior or it may change? It's highly unlikely to change, since that would break countless applications. Also, is there a function in the API to

Re: [sqlite] Is sqlite case-sensitive?

On Sun, May 18, 2014 at 4:37 PM, Baruch Burstein wrote: > > names), or without context (just validate syntax, e.g. that it can be > > parsed)? > > > I am asking about this API since I think I remember seeing it once, but > can't find it now > i _think_ what you want is:

Re: [sqlite] Is sqlite case-sensitive?

On Sun, May 18, 2014 at 5:32 PM, Baruch Burstein wrote: > Sqlite is case-insensitive as far as table/column/db names. Is this > documented as official behavior or it may change? > > Also, is there a function in the API to validate a SQL statement, either > in the context of

[sqlite] Is sqlite case-sensitive?

Sqlite is case-insensitive as far as table/column/db names. Is this documented as official behavior or it may change? Also, is there a function in the API to validate a SQL statement, either in the context of the current connection (validate also table/column/db names), or without context (just