Dustin S Houck wrote:
If you want column names to be case sensitive you can put them in double quotes.Hello,I have been playing around with derby to determine if we want to use it in a project at my work. I have the db set up and populating the db with table and am able to connect to the db using jdbc. But after playing around with it and completing some queries it appears the derby returns query results with table names and column names in all caps (even though I created then in lower case using the ij tool). Is this correct? Has derby been implemented to always return table names and column names in uppercase? (this seems odd to me, since the derby db is “case sensitive”) Are there any settings/workarounds to fix this??
e.g.
ij version 10.3
ij> connect 'jdbc:derby:wombat;create=true';
ij> create table t ("lower" int);
0 rows inserted/updated/deleted
ij> select * from t;
lower
-----------
0 rows selected
