Donald McLean wrote:
At least one case was documented on the Wiki:
http://wiki.apache.org/db-derby/DerbySQLroutines
(under Common Problems, at the bottom)
If you mean SYSCS_IMPORT_DATA (which is a SQL routine) then it seems to
follow the same rules as the Java methods, case sensitive, I was asking
for Java methods that are case insensitive for table names. Ie. passing
in mytable would match the table created by any of
create table mytable ...
create table MYTABLE ...
create table myTable ...
create table "MYTABLE" ...
All of which would create a table with the name MYTABLE.
JDBC DatabaseMetadata methods require that the passed in table name
match the actual table name, in this case MYTABLE.
Dan.
On Jan 4, 2008 2:27 PM, Daniel John Debrunner <[EMAIL PROTECTED]> wrote:
blyon wrote:
Thanks for the advice, it works as expected when I use ALL UPPER CASE. But,
isn't it rather odd that some functions are case-sensitive for table names
and others are not?
I'm curious, which methods are case-insensitive for table names?
