He is my vote. I like the fact that conventions #1 and #2 make things compatible with other databases. Does #3, by chance, do the same with another database not mentioned (eg. Oracle).
If it does not have any compatibility with any other database, ONLY then I say that one should drop #3 quoting convention. Palmer > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org > Date: Thu, 7 Aug 2008 13:26:07 -0400 > Subject: [sqlite] Proposed removal of (mis-)feature > > String literals in SQL are suppose to be enclosed in single-quotes - > Pascal-style. Double-quotes are used around table and/or column names > in cases where the name would otherwise be a keyword or when the name > contains non-standard characters. > > But SQLite tries to be flexible and accommodating. To this end, it > accepts some non-standard quoting mechanisms: > > 1. Names can be enclosed in [...] for compatibility with Access > and SQLServer. > 2. Names can be enclosed in grave accents for compatibility with > MySQL. > 3. Double-quoted names fall back to being string literals if > there is no matching table or column name. > > In retrospect, (3) seems to be a bad idea. It is accident-prone and > leads to all kinds of confusion. For example, if double-quotes are > being used correctly (which is to say to quote table or column names) > but a misspelling occurs in the name, the token reverts to being a > string literal rather than throwing an error. Or if a double-quoted > string really is being used as a string literal, but later a new > column is added to a table that has the same name as the string text, > the string literal will suddenly take on the value of the column. It > seems like we have one or two problem reports per month on this > mailing list that involve people using double-quoted names where they > should be using single-quoted string literals instead. > > So I'm giving some thought to removing feature (3) above and > disallowing double-quoted string literals. My concern is, though, > that this might break many existing applications. > > What opinion do you, gentle users, have of this matter? > > D. Richard Hipp > [EMAIL PROTECTED] > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _________________________________________________________________ Get more from your digital life. Find out how. http://www.windowslive.com/default.html?ocid=TXT_TAGLM_WL_Home2_082008 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
