Add option to disable the double-quoted string literal misfeature by default
JesseChavez opened this issue · 1 comments
JesseChavez commented
Is your feature request related to a problem? Please describe.
It would be good to have a configuration property to disable the misfeature described in the title
Having this will disable undesired behaviour described by the SQLite creator in the following link
https://www.sqlite.org/quirks.html#double_quoted_string_literals_are_accepted
Here is a like of a specific undesired behaviour
Describe the solution you'd like
Something we can pass in the connection url would be good.
e.g.
jdbc:sqlite:db.sqlite?strict_strings=true
Additional context
Here is a example how a configuration property was added to library that uses SQLite's C API.
gotson commented
can you explain what you are referring to by "the double-quoted string literal misfeature" ?