kickstart Posted November 4, 2009 Share Posted November 4, 2009 Hi I am trying to extract the contents of an Access database into SQLite so it can be downloaded and used in another app. One of the table names has a space in it and if I can I would prefer to keep all the table and column names the same. However I cannot see how to delimit table names in SQLite to allow me to use spaces. I have tried delimiting with `, [] and ", and all result in an invalid database. All the best Keith Link to comment https://forums.phpfreaks.com/topic/180260-sqlite-and-table-names-with-spaces/ Share on other sites More sharing options...
PFMaBiSmAd Posted November 4, 2009 Share Posted November 4, 2009 Double-quotes should work. Is there a chance that the name is all numeric characters? I would convert spaces to an under-score Link to comment https://forums.phpfreaks.com/topic/180260-sqlite-and-table-names-with-spaces/#findComment-950921 Share on other sites More sharing options...
nadeemshafi9 Posted November 4, 2009 Share Posted November 4, 2009 yes bad idea to keep spaces in table names but you just hit the reason why Link to comment https://forums.phpfreaks.com/topic/180260-sqlite-and-table-names-with-spaces/#findComment-950922 Share on other sites More sharing options...
kickstart Posted November 4, 2009 Author Share Posted November 4, 2009 Quote Double-quotes should work. Is there a chance that the name is all numeric characters? I would convert spaces to an under-score Double quotes do work for column names, but don't appear to work for table names. In many ways I would prefer to use underscores, but would also prefer to keep the table names the same between the master copy and the SQLite extract copy. I really wish people wouldn't use spaces in any table or column name, or any reserved words :'( . All the best Keith Link to comment https://forums.phpfreaks.com/topic/180260-sqlite-and-table-names-with-spaces/#findComment-950943 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.