Hi, > setting or mode in h2 where table names and > column names are always completely case sensitive > (whether quoted or not.)
Yes, MS SQL Server is doing something similar (identifiers are not case sensitive, but the original case is stored). I agree compatibility modes for the various databases need to be improved. > require keywords to be all uppercase, so you could use any lowercase or > camelcase word as an identifier. I don't think I want to support this. First of all, it would no longer be SQL or compatible with any database. Then, it would look kind of ugly: SELECT id, name FROM test; If at all, I would like to "enforce" lowercase keywords: select Id, Name from Test; But I'm not sure about that. Enforcing keyword case is not compatible with any other database I know. I'm thinking about switching the documentation to use lowercase keywords, but that would be a bigger change. Even in the SQLite documentation everything is uppercase. > we'll send it to Thomas as one larger patch. I actually prefer smaller patches. I think it's possible to split it into multiple smaller patches. But I guess it's easier if I implement it myself. Regards, Thomas -- 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.
