o shoot yourself in the foot, I am sure H2
> will present multiple opportunities for that.
> Does it really matter if it end up with "table not found" or will select
> from one or the other table, at random?
> Of course, you are always welcome to try...
>
> On Saturday, Janua
Thanks. Appreciate the quick and comprehensive response. Can you explain
this a bit more: "It is possible to specify them in the default Regular
compatibility mode "
Just curious, since the settings can't persist... what would happen if, in
default mode, I created MyTable and also "mytable"
What is the difference between IGNORE_CASE and CASE_INSENSITIVE_IDENTIFIERS
in the connection string?
H2 defaults to being case-sensitive. I prefer the opposite. Is it possible
to set a permanent case-insensitivity option when a new database is
initially created, and not have to rely on the