On 7 Dec 2010, at 08:49, 곽현미 wrote: > Anyone please give me an advise, > > when i try the query below, > > CREATE TABLE "Test]" (no INTEGER), > > sqlite gives me the 'unrecognized token: "]" ' result. > > Is there a way to escape the ']' character in the identifier?
Use the right quotes, single not double; this works for me: create table 'test]' (no integer); Best Regards, Phil Willoughby -- Managing Director, StrawberryCat Limited StrawberryCat Limited is registered in England and Wales with Company No. 7234809. The registered office address of StrawberryCat Limited is: 107 Morgan Le Fay Drive Eastleigh SO53 4JH _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users