That's not an SQLitespeed feature but indeed a backwards-compatible SQLite feature. (I had this wrong too at some point)
You probably already know, but to be clear: In SQL standard, double-quotes indicate identifiers and single quotes indicate string values. While the single quotes are used more or less universally, identifiers often get quoted differently. In Postgres and SQLite the standard is adhered to with Double quotes. MySQL uses a back-tick like this ` (which, by the way, will also work in SQLite due the same backward compatibility) MSSQL likes the square brackets [ and ] around identifiers (which, again, also works in SQLite for the same reason) Further to this, in earlier MySQL and in SQLite you may also use double quotes to denote strings, and it will regard a double-quoted value to be a string if A - it isn't an identifier, or B - used in a place where you can't use an identifier. (You can just imagine the bugs in your SQL that can arise from this!) While all of the above works, you are strongly encouraged to simply do it correctly and use double-quotes for identifiers and single quotes for strings. We have been lobbying for a strict-mode in SQLite where none of these shenanigans are allowed - but that is far easier said than done. On 2016/02/09 5:10 PM, Chris Prakoso wrote: > Actually I've just done it now, in SQLiteSpeed, and it allowed me to use > double-quote as delimiter successfully. > > Regards, > Chris > > On Tue, Feb 9, 2016 at 3:03 PM, Simon Slavin <slavins at bigfraud.org> wrote: > >> On 9 Feb 2016, at 12:10pm, Chris Prakoso <chris at prakoso.net> wrote: >> >>> *insert into test (field1,field2) values (1,"two"),(2,"three")* >> As well as the comments about your software being out of date, you need to >> know that the text delimiter in SQLite is the non-directional single quote >> character normally seen as an apostrophe. You cannot successfully use the >> double quote character or any directional quotes. >> >> Should be >> >> insert into test (field1,field2) values (1,'two'),(2,'three') >> >> Simon. >> _______________________________________________ >> sqlite-users mailing list >> sqlite-users at mailinglists.sqlite.org >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >> > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
