Following up: > This also says that SQLite will accept a single quoted literal as an > identifier in certain situations. I'm not aware of any other > database that used single quotes that way, but I'm sure there was > one somewhere along the line.
It is a pain that SQLite accepts single quoted identifiers. It is worse and, I suggest, a bug that SQLite also _creates_ single quoted identifiers after when renaming a table. eg: create table MyTable( MyField ); alter table MyTable rename to MyNewTable; select SQL from SQLite_Master; which gives: CREATE TABLE 'MyNewTable'( MyField ) SQLite should instead use the quotes (if any) used in the alter table command. Tom BareFeet _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users