On Aug 26, 5:38 pm, Joe Wilson <[EMAIL PROTECTED]> wrote: > SQL identifiers are not case sensitive. I'm not sure what the JDBC > spec says regarding how metadata should be returned, but most JDBC > drivers I've seen return uppercase for table and column names, and > leave it to the user to normalize. > > Since sqlite_master is unique to SQLite, and out of scope of any spec, > you could do this: > > select * from sqlite_master where name = 'V_TEST' collate nocase; > Thanks for the answer.
I don't think there is a spec regarding in which case getTables() should return the names, but my experience with JDBC drivers is that they return the names as stored in the database (so Postgres will return lowercase identifiers, Oracle uppercase, SQL Server whatever the user entered) --~--~---------~--~----~------------~-------~--~----~ Mailing List: http://groups.google.com/group/sqlitejdbc?hl=en To unsubscribe, send email to [EMAIL PROTECTED] -~----------~----~----~----~------~----~------~--~---
