> -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Richard Hipp > Sent: Monday, December 08, 2014 1:28 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Table names length and content > > On Mon, Dec 8, 2014 at 1:22 PM, jose isaias cabrera > <jic...@cinops.xerox.com > > wrote: > > > > > "Stephan Beal" wrote... > > > > On Mon, Dec 8, 2014 at 6:32 PM, jose isaias cabrera < > >> jic...@cinops.xerox.com > >> > >>> wrote: > >>> > >> > >> When creating table names, are there any constraints that one must > >> look > >>> for? ie. Length? Characters? etc.? I quickly browse through this > >>> spot, > >>> > >>> https://www.sqlite.org/lang_createtable.html > >>> > >> > >> > >> https://www.sqlite.org/limits.html > >> > >> might have what you're looking for. > >> > > > > Hmmm... what I am looking for it is not there. If the "string > length" > > defined there is what defines the length of the name of a table, I am > > in business. :-) However, there is nothing about problematic > characters. ie. > > <>!@#$%^&*()_+=-{}\|[]'";:?/.,, etc., etc. in the table name. > > > > > Put the table name in double-quotes.
Uh oh! I never use quotes when I create my tables. What are the implications of not quoting? -Bill CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any attachments are solely for the use of the addressee and may contain information that is privileged or confidential. Any disclosure, use or distribution of the information contained herein is prohibited. In the event this e-mail contains technical data within the definition of the International Traffic in Arms Regulations or Export Administration Regulations, it is subject to the export control laws of the U.S.Government. The recipient should check this e-mail and any attachments for the presence of viruses as L-3 does not accept any liability associated with the transmission of this e-mail. If you have received this communication in error, please notify the sender by reply e-mail and immediately delete this message and any attachments. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
