Hi Thanks, I will try it. It might take a few days (I'm on vacation right now).
Regards, Thomas Am 07.10.2011 11:09 schrieb "Sije de Haan" <[email protected]>: > > > On 30 sep, 21:52, Thomas Mueller <[email protected]> wrote: > > Hi, > > > > I know it is not fully compatible. Currently, H2 internally uses a > > HashMap<String, Table>, and it is not so easy to make this case > insensitive. > > Patches are welcome of couse :-) > > > > Regards, > > Thomas > > Am 30.09.2011 16:13 schrieb "Sije de Haan" <[email protected]>: > > > > Adding an extra jar is not necessary, I implemented a > CaseInsensitiveHashMap myself, it's only one small source (with a test > program). Download it from > http://www.dehaansoftware.nl/CaseInsensitiveHashMap.zip > > Sije > > > > > > > > > > > > > > When I set the DATABASE_TO_UPPER property set to false Table- and > > > FieldNames are 'stored-as-is', so when I execute 'CREATE TABLE > > > Customers ...' and retrieve the metaData I get 'Customers'. That's > > > what I want and that's what I need. > > > > > But what I don't want is to ACCESS the table in a case-sensitive way. > > > When I execute two queries: > > > SELECT * from Customers > > > and > > > SELECT * from CUSTOMERS > > > I expect both to return the same results because the SQL standard says > > > that sql statements should be interpreted in a case-insensitive way. > > > With the DATABASE_TO_UPPER set to false I even can execute: > > > CREATE TABLE customers > > > and > > > CREATE TABLE Customers > > > ending up with two different tables where the SQL Standard requires > > > the second to throw a 'Table already exists' exception. > > > > > The changelog says: > > > "DATABASE_TO_UPPER: when set to false, all identifier names (table > > > names, column names) are case sensitive (except aggregate, built-in > > > functions, data types, and keywords). This is for improved > > > compatibility with MySQL and PostgreSQL" > > > But it's not compatible with MySQL at all (and I doubt it is with > > > PostgreSql) > > > > > Sije de Haan > > > > > -- > > > You received this message because you are subscribed to the Google > Groups > > > > "H2 Database" group.> To post to this group, send email to > [email protected]. > > > To unsubscribe from this group, send email to > > > > [email protected].> For more options, visit this > group at > > > > http://groups.google.com/group/h2-database?hl=en. > > > > > > > > > > > > > > > > > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
