On 2014/03/27 12:12, Clemens Ladisch wrote:
RSmith wrote:
Double quotes are not part of the standard, just allowed by most systems in
lieu of single quotes
No. To quote <http://www.sqlite.org/lang_keywords.html>:
| There are four ways of quoting keywords in SQLite:
|
| 'keyword' A keyword in single quotes is a string literal.
| "keyword" A keyword in double-quotes is an identifier.
| [keyword] A keyword enclosed in square brackets is an identifier.
| This is not standard SQL. This quoting mechanism is used by
| MS Access and SQL Server and is included in SQLite for
| compatibility.
| `keyword` A keyword enclosed in grave accents (ASCII code 96) is an
| identifier. This is not standard SQL. This quoting
| mechanism is used by MySQL and is included in SQLite for
| compatibility.
Thanks for this, I stand corrected - knowing it was vague on implementation but I was convinced before now that the double quotes
were simply alternates to single quotes in SQLite too... Good to learn!
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
