On 2/9/16, Chris Prakoso <chris at prakoso.net> wrote: > Actually I've just done it now, in SQLiteSpeed, and it allowed me to use > double-quote as delimiter successfully. >
That is supported for backwards compatibility. I originally put in support for double-quoted string literals to be compatible with MySQL 3.5. I have long since regretted that decision. You are encouraged to use single-quotes for string literals, as double-quotes have a very different meaning that can lead to subtle bugs. -- D. Richard Hipp drh at sqlite.org