Case Sensitivity

2010-03-24 Thread Pavel Bortnovskiy
Hello, all: when executing a statement, such as: select Id as id, Code as code, TypeStr as typeStr from MyTable against a Derby in-memory table, the ResultSetMetaData present column names all

Re: Case Sensitivity

2010-03-24 Thread Peter Ondruška
select Id as id, Code as code, TypeStr as typeStr from MyTable On Wed, Mar 24, 2010 at 10:30 PM, Pavel Bortnovskiy pbortnovs...@jefferies.com wrote: Hello, all: when executing a statement, such as:                

Re: Case Sensitivity

2010-03-24 Thread Pavel Bortnovskiy
Discussion derby-user@db.apache.org To Derby Discussion derby-user@db.apache.org cc Subject Re: Case Sensitivity select Id as id, Code as code, TypeStr as typeStr from MyTable On Wed, Mar 24, 2010 at 10:30 PM, Pavel

Re: Case Sensitivity

2010-03-24 Thread Peter Ondruška
), so that the quotes could be omitted? *Peter Ondruška peter.ondru...@gmail.com* 03/24/2010 05:33 PM Please respond to Derby Discussion derby-user@db.apache.org To Derby Discussion derby-user@db.apache.org cc Subject Re: Case Sensitivity select Id as id

Re: Case Sensitivity

2010-03-24 Thread Mark Thornton
Peter Ondruška wrote: Not that I know, this is by SQL standard. On Wed, Mar 24, 2010 at 10:43 PM, Pavel Bortnovskiy pbortnovs...@jefferies.com mailto:pbortnovs...@jefferies.com wrote: Thank you, Peter, for your prompt response. Is enclosing them in quotes the only way to do so? Is