On Wed, Mar 26, 2014 at 6:12 PM, RSmith <[email protected]> wrote: > > Also, why all the Double-quotes around your column names in the create > statement? I'm sure it will work but it isn't the right SQL compatible > method, either use SQL backquotes or no quotes. Single and double quotes > (preferably single quotes) in general should only indicate string values, > not object names. > > Double quotes are part of the SQL-92 standard. I'm pretty sure they are, anyway. They are used (along with other database specific means) to delimit identifiers that would otherwise be illegal. As for using backtick to delimit identifiers, it is not mentioned in the standard. Again, as I understand it. This seems to cover it in some detail: http://stackoverflow.com/questions/10573922/what-does-the-sql-standard-say-about-usage-of-backtick
SDR _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
