2011/6/6 Jean-Christophe Deschamps <j...@antichoc.net>: >>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" Or, what you can also do is use table names such as no_special_chars and/or do_not_distinguish_between_caps_and_lower_case_in_designing_system ? Paul... -- lineh...@tcd.ie Mob: 00 353 86 864 5772 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users