Re: [sqlite] Table names length and content

2014-12-08 Thread Keith Medcalf
why. >-Original Message- >From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- >boun...@sqlite.org] On Behalf Of Drago, William @ CSG - NARDAEAST >Sent: Monday, 8 December, 2014 11:38 >To: General Discussion of SQLite Database >Subject: Re: [sqlite] Table names

Re: [sqlite] Table names length and content

2014-12-08 Thread jose isaias cabrera
"Richard Hipp" wrote... On Mon, Dec 8, 2014 at 1:36 PM, Roger Binns wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/08/2014 10:30 AM, jose isaias cabrera wrote: >>> Hmmm... what I am looking for it is not there. If the "string >>> length" defined there is

Re: [sqlite] Table names length and content

2014-12-08 Thread Drago, William @ CSG - NARDAEAST
te.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Stephan Beal > Sent: Monday, December 08, 2014 1:41 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Table names length and content > > On Mon, Dec 8, 2014 at 7:37 PM, Drago, William @ CSG - NARDAEAST <

Re: [sqlite] Table names length and content

2014-12-08 Thread Richard Hipp
On Mon, Dec 8, 2014 at 1:36 PM, Roger Binns wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > On 12/08/2014 10:30 AM, jose isaias cabrera wrote: > >>> Hmmm... what I am looking for it is not there. If the "string > >>> length" defined there is what defines the

Re: [sqlite] Table names length and content

2014-12-08 Thread Stephan Beal
On Mon, Dec 8, 2014 at 7:37 PM, Drago, William @ CSG - NARDAEAST < william.dr...@l-3com.com> wrote: > Uh oh! I never use quotes when I create my tables. What are the > implications of not quoting? > If you restrict yourself to C-style identifiers, the primary implication is better ease of use

Re: [sqlite] Table names length and content

2014-12-08 Thread Stephan Beal
On Mon, Dec 8, 2014 at 7:36 PM, Roger Binns wrote: > SQLite supports all those, as well as zero length table names, column > types and names. > > > sqlite> create table " <>!@#$%^&*()_+=-{}\|[]'"";:?/.,, etc., etc. in > the table name"("" ""); > To whichl add: sqlite

Re: [sqlite] Table names length and content

2014-12-08 Thread Drago, William @ CSG - NARDAEAST
> -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

Re: [sqlite] Table names length and content

2014-12-08 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 12/08/2014 10:30 AM, jose isaias cabrera wrote: >>> 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

Re: [sqlite] Table names length and content

2014-12-08 Thread jose isaias cabrera
"Richard Hipp" wrote... On Mon, Dec 8, 2014 at 1:22 PM, jose isaias cabrera

Re: [sqlite] Table names length and content

2014-12-08 Thread Richard Hipp
On Mon, Dec 8, 2014 at 1:22 PM, jose isaias cabrera 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

Re: [sqlite] Table names length and content

2014-12-08 Thread jose isaias cabrera
"Stephan Beal" wrote... On Mon, Dec 8, 2014 at 6:32 PM, jose isaias cabrera

Re: [sqlite] Table names length and content

2014-12-08 Thread Stephan Beal
On Mon, Dec 8, 2014 at 6:32 PM, jose isaias cabrera 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

[sqlite] Table names length and content

2014-12-08 Thread jose isaias cabrera
Greetings! 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 but could not find any information regarding this. Would someone please bring light for