Dennis Cote <[EMAIL PROTECTED]> wrote:
> Yves Goergen wrote:
> > Hi,
> >
> > I've tested my own SQLite application's identifier quoting capabilities
> > now and found that the SQLite engine has serious problems with
> > table/column names containing certain special characters. Just try the
> > following:
> >
> > CREATE TABLE "t a" ("c a", """cb""");
> > INSERT INTO "t a" ("c a", """cb""") VALUES (1, 2);
> > INSERT INTO "t a" ("c a", """cb""") VALUES (11, 12);
> > INSERT INTO "t a" ("c a", """cb""") VALUES (21, 22);
> > SELECT * FROM "t a";
> >
>
> You should file a bug ticket at
> http://www.sqlite.org/cvstrac/captcha?nxp=/cvstrac/tktnew since these
> are all valid quoted SQL identifiers.
>
http://www.sqlite.org/cvstrac/tktview?tn=2450
--
D. Richard Hipp <[EMAIL PROTECTED]>
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
