RE: [sqlite] RFC Beginning digit in column name

2005-08-15 Thread Ned Batchelder
: Wednesday, 10 August, 2005 4:23 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] RFC Beginning digit in column name Hello there, I think that adhering to standards is a Very Good Thing(tm). They are standards for a reason. Deviations can introduce ambiguity, confusion, complexity, vendor lock-ins

Re: [sqlite] RFC Beginning digit in column name

2005-08-10 Thread John LeSueur
Marcus Welz wrote: Hello there, I think that adhering to standards is a Very Good Thing(tm). They are standards for a reason. Deviations can introduce ambiguity, confusion, complexity, vendor lock-ins and all sorts of other headaches. That said, however, I believe that "no, because it's not

RE: [sqlite] RFC Beginning digit in column name

2005-08-10 Thread Marcus Welz
th MySQL to also offer a SQLite version with little effort. How off the wall am I with this? -m -Original Message- From: Austin Ziegler [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 10, 2005 2:44 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] RFC Beginning digit in column name On 8

Re: [sqlite] RFC Beginning digit in column name

2005-08-10 Thread Jay Sprenkle
On 8/10/05, Austin Ziegler <[EMAIL PROTECTED]> wrote: > > What are your reasons for thinking supporting '`' is a bad idea? > > 1. It's not part of the standard. LOL! Standards are great! Everybody should have several. ;)

Re: [sqlite] RFC Beginning digit in column name

2005-08-10 Thread Austin Ziegler
On 8/10/05, ender <[EMAIL PROTECTED]> wrote: > Austin Ziegler wrote: >>On 8/9/05, ender <[EMAIL PROTECTED]> wrote: >>> So my simple feature request would be: allow '`' as a quoting symbol - >>> as mySQL does. Or - what would be as helpful as the other idea - allow >>> unquoted column names with

Re: [sqlite] RFC Beginning digit in column name

2005-08-10 Thread ender
Austin Ziegler wrote: On 8/9/05, ender <[EMAIL PROTECTED]> wrote: So my simple feature request would be: allow '`' as a quoting symbol - as mySQL does. Or - what would be as helpful as the other idea - allow unquoted column names with leading digits - as mySQL does. Also see ticket #

Re: [sqlite] RFC Beginning digit in column name

2005-08-09 Thread Kurt Welgehausen
> Does MySQL allows [0_xy] to specify column names? > > If I remember correctly, that is the standard SQL way to have columns > with spaces in the middle, and sqlite allows columns starting with a > digit in this way... It's not standard; it's a Microsoft extension. Regards

Re: [sqlite] RFC Beginning digit in column name

2005-08-09 Thread Austin Ziegler
On 8/9/05, Nuno Lucas <[EMAIL PROTECTED]> wrote: > [09-08-2005 19:05, ender escreveu] > [...] >> So my simple feature request would be: allow '`' as a quoting >> symbol - as mySQL does. Or - what would be as helpful as the >> other idea - allow unquoted column names with leading digits - as >>

Re: [sqlite] RFC Beginning digit in column name

2005-08-09 Thread Darren Duncan
At 8:46 PM +0100 8/9/05, Nuno Lucas wrote: [09-08-2005 19:05, ender escreveu] [...] So my simple feature request would be: allow '`' as a quoting symbol - as mySQL does. Or - what would be as helpful as the other idea - allow unquoted column names with leading digits - as mySQL does. Does

Re: [sqlite] RFC Beginning digit in column name

2005-08-09 Thread Nuno Lucas
[09-08-2005 19:05, ender escreveu] [...] > So my simple feature request would be: allow '`' as a quoting symbol - > as mySQL does. Or - what would be as helpful as the other idea - allow > unquoted column names with leading digits - as mySQL does. Does MySQL allows [0_xy] to specify column names?

Re: [sqlite] RFC Beginning digit in column name

2005-08-09 Thread Austin Ziegler
On 8/9/05, ender <[EMAIL PROTECTED]> wrote: > > Dear developers, > > a while back, our project decided to switch from mysql to usage of > various SQL backends, among this sqlite3 as our favorite. Now recently > we encountered a problem, just a tiny one, but one we are not able to > solve with

[sqlite] RFC Beginning digit in column name

2005-08-09 Thread ender
Dear developers, a while back, our project decided to switch from mysql to usage of various SQL backends, among this sqlite3 as our favorite. Now recently we encountered a problem, just a tiny one, but one we are not able to solve with all used SQl backends in a common sense. The problem