Re: [sqlite] Is sqlite case-sensitive?

On Sun, May 18, 2014 at 9:46 PM, James K. Lowden wrote: > I can easily imagine uses for a generalized SQLite parser, one that > returned an abstract syntax tree. A program might use such a thing for > all sorts of "server-side" functionality, for example to process a >

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] 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

RE: [sqlite] Is SQLite Case Sensitive?

, Lee Crain __ -Original Message- From: Dwight Ingersoll [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 08, 2007 5:11 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is SQLite Case Sensitive? --- Lee Crain <[EMAIL PROTECTED]> wrote: > I a

Re: [sqlite] Is SQLite Case Sensitive?

--- Lee Crain <[EMAIL PROTECTED]> wrote: > I am working on an application where I am importing > data for which great care has NOT been taken to > ensure uppercase and lowercase letters have been > entered appropriately. Just a suggestion: This sounds like it's a candidate for some data

RE: [sqlite] Is SQLite Case Sensitive?

lite.org Subject: Re: [sqlite] Is SQLite Case Sensitive? SQL is not case-sensitive, but SQL comparisons are. Use the following SELECT * FROM table WHERE field1 = 'a' OR field1 = 'A' you can also use WHERE Lower(field1) = 'a' or

Re: [sqlite] Is SQLite Case Sensitive?

ent result than a search for an > 'A'? Yes. SQLite is case-sensitive. If you are only using ASCII, you can create an index using COLLATE NOCASE - otherwise you'll have to add your own collation. > > SELECT * FROM table WHERE field1 = 'a'; > > V

Re: [sqlite] Is SQLite Case Sensitive?

; > > Vs. > > SELECT * FROM table WHERE field1 = 'A'; > > > If SQLite is case sensitive, is there an easy override for this to enforce > all lowercase letters? > > Thanks, > > Lee Crain > > > > --

[sqlite] Is SQLite Case Sensitive?

= 'a'; Vs. SELECT * FROM table WHERE field1 = 'A'; If SQLite is case sensitive, is there an easy override for this to enforce all lowercase letters? Thanks, Lee Crain - To unsubscribe, send email to [EMAIL