RE: [sqlite] RDBMS handling of column names (was: Trouble with column names)

2005-04-27 Thread Drew, Stephen
To: sqlite-users@sqlite.org Subject: Re: [sqlite] RDBMS handling of column names (was: Trouble with column names) Hello Dr. Hipp, Hello dear sqlite users, > > And I don't really think I'm asking much: all I want is that when I > > ask for > > Field1 column, the database engin

Re: [sqlite] RDBMS handling of column names (was: Trouble with column names)

2005-04-27 Thread George Ionescu
Hello Dr. Hipp, Hello dear sqlite users, > > And I don't really think I'm asking much: all I want is that when I ask for > > Field1 column, the database engine to report Field1 and not FIELD1. > > > > Set PRAGMA short_column_names=OFF; and that will happen. > Why doesn't that solution work for

Re: [sqlite] RDBMS handling of column names (was: Trouble with column names)

2005-04-27 Thread D. Richard Hipp
On Wed, 2005-04-27 at 15:53 +0300, George Ionescu wrote: > And I don't really think I'm asking much: all I want is that when I ask for > Field1 column, the database engine to report Field1 and not FIELD1. > Set PRAGMA short_column_names=OFF; and that will happen. Why doesn't that solution work

Re: [sqlite] RDBMS handling of column names (was: Trouble with column names)

2005-04-27 Thread George Ionescu
Hello Clay, thanks for replying to the message, > I suspect very strongly that most SQLite users are submitting themselves > to that discipline which I suggested in an earlier message, principally > that we don't expect SQLite to cover for our own inconsistencies in column > naming. The

Re: [sqlite] RDBMS handling of column names (was: Trouble with column names)

2005-04-27 Thread Clay Dowling
George Ionescu said: > ask for? Please understand that I'm not trying to criticise anything or > anyone: I'm just trying to understand why this has happened and why people > do not complain about it. George, I suspect very strongly that most SQLite users are submitting themselves to that

Re: [sqlite] RDBMS handling of column names (was: Trouble with column names)

2005-04-27 Thread George Ionescu
Hello Dr. Hipp, Hello dear sqlite users, following my previous post: I did not know that I'm not allowed to post attachments in this group... I've added the document which compares how SQL Server, MySQL and sqlite treats column names as an attachment to the wiki page