On Sep 30, 4:15 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm interested in using Sequel with sqlite3, but I see that > "sequel_core/adapters/shared/sqlite.rb" has a "quoted_identifier" > method that puts backticks around identifiers. Does sqlite3 use > backticks like this? I didn't think that it did: > > $ sqlite3 my.db <<<'CREATE TABLE `items`;' > SQL error: unrecognized token: "`" > > This seems like a very trivial error! Perhaps I am doing something > wrong? I'm using Sequel 2.5.0, fwiw, on Debian etch with sqlite > 3.2.1.
It works on my system, using sqlite 3.4.2: $ sqlite3 SQLite version 3.4.2 Enter ".help" for instructions sqlite> CREATE TABLE `items` (`blah` integer); sqlite> .dump BEGIN TRANSACTION; CREATE TABLE `items` (`blah` integer); COMMIT; If there is another identifier quoting mechanism that is more backwards compatible without losing forwards compatibility, I have no problem switching. 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 -~----------~----~----~----~------~----~------~--~---
