Re: [sqlite] Minus sign in table name

D. Richard Hipp wrote: > > > On May 4, 2009, at 10:18 AM, bitzzz wrote: > >> >> I am converting an existing database to sqlite format, but I got the >> following problem: >> >> When I create a table name with a minus sign inside then the followin

[sqlite] Minus sign in table name

I am converting an existing database to sqlite format, but I got the following problem: When I create a table name with a minus sign inside then the following column definitions are ignored. So: CREATE TABLE 'TEST1-TEST' (TST TEXT); refuses to create the column TST in the table TEST1-TEST. The