On Wed, May 16, 2012 at 2:25 PM, Simon Slavin <slav...@bigfraud.org> wrote:
> > On 16 May 2012, at 11:56am, Petite Abeille <petite.abei...@gmail.com> > wrote: > > > On May 16, 2012, at 12:28 PM, <ma...@sqlabs.net> <ma...@sqlabs.net> > wrote: > > > >> Anyone have an answer? > > > > http://www.sqlite.org/lang_keywords.html > > > >> What about if table name or column name contains that escape character? > >> Do I need to escape it in another way? > > > > http://sqlite.org/faq.html#q14 > > Doesn't answer the question of what to do if your table name includes a > double-quote character. > > And nor can I, except to say that if I saw such a thing I'd run away. > > A quick testing shows it works the same for double-quoted column names, e.g. sqlite> create table "q""w" (t); sqlite> .tables q"w -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
