Quoth Philip Graham Willoughby <phil.willoug...@strawberrycat.com>, on 2010-12-07 10:57:45 +0000: > Use the right quotes, single not double; this works for me: > > create table 'test]' (no integer);
Yagh! Please don't call those the 'right' quotes in this case. Quoth http://sqlite.org/lang_keywords.html: | For resilience when confronted with historical SQL statements, | SQLite will sometimes bend the quoting rules above: | | * If a keyword in single quotes (ex: 'key' or 'glob') is used in a | context where an identifier is allowed but where a string | literal is not allowed, then the token is understood to be an | identifier instead of a string literal. | | * If a keyword in double quotes (ex: "key" or "glob") is used in a | context where it cannot be resolved to an identifier but where a | string literal is allowed, then the token is understood to be a | string literal instead of an identifier. | | Programmers are cautioned not to use the two exceptions described in | the previous bullets. We emphasize that they exist only so that old | and ill-formed SQL statements will run correctly. Future versions of | SQLite might change to raise errors instead of accepting the malformed | statements covered by the exceptions above. (I suspect the real answer is "don't do that", but I'm not entirely confident.) ---> Drake Wilson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
