[h2] questions about case sensitivity

2023-01-13 Thread AndyGo
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 co

[h2] Re: questions about case sensitivity

2023-01-13 Thread Evgenij Ryazanov
Hello! These settings aren't related to each other. IGNORE_CASE is about *data types* and their *values*. It replaces CHARACTER VARYING (VARCHAR) columns in DDL commands with VARCHAR_IGNORECASE data type. This legacy setting should never be used, it is much better to specify some case-insensit