On Mon, Jun 6, 2011 at 6:14 AM, Jean-Christophe Deschamps <j...@antichoc.net>wrote:
> > >What is the official way to escape table name that contains a space > >and column name that contain a spaces? > > You can use square brakets or double-quotes: > > [This is a long name for a small table] > "This is a long name for a small table as well" > > Double-quotes is the official (portable) SQL way of quoting identifiers. Square bracket quoting is provided by SQLite for compatibility with SQL Server. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
