I'm having an issue when using the TABLE function that comparison is case sensitive.
http://www.h2database.com/html/functions.html#table Here is the query I'm using: SET @jobstatus = ?; SELECT * FROM mytable WHERE jobstatus IN (SELECT jobstatus FROM table(jobstatus VARCHAR_IGNORECASE = @jobstatus); In code, I'm setting the @jobstatus variable with a String array. The result is only values inside the jobstatus column that exactly match the case of the values I put inside the String array @jobstatus. Using the LOWER or UPPER function as SELECT * FROM mytable WHERE jobstatus IN (SELECT LOWER(jobstatus) FROM table(LOWER(jobstatus) VARCHAR_IGNORECASE = @jobstatus); does resolve the issue but in my situation would require the user to enter this function in our UI so it's really practical. Is there some setting or connection parameter that will allow this to be case insensitive? I'm currently have to use DATABASE_TO_UPPER=FALSE in my connection string. Thanks, Chris -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
