On Jun 8, 4:57 pm, Jeremy Evans <[email protected]> wrote: > Historically, Sequel has quoted identifiers on SQLite using `, but it > turns out that isn't the recommended method, it's only used for > compatibility with MySQL (http://www.sqlite.org/lang_keywords.html). > Any objections to changing the identifier quoting to the SQL standard > "?
I've decided against doing this, as SQLite has a misfeature where it will treat an " quoted identifier as a string in some places (places where usage of an identifier will raise an error), but will not treat a ` quoted identifier as a string in the same place (an error will be raised). It's possible that this is the reason ` has been used for quoting identifiers on SQLite all along. Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
