Virtually Nick

Got it - I'll take a run at it.

The generally accepted method for PostgreSQL to do case-insensitive searches/comparisons seems to be to use the `lower()` function to convert both strings to lower-case before the comparison. MySQL appears to...

> The other issue will be with database queries. IIRC, MySQL/MariaDB is case-insensitive for username queries, but PostgreSQL is case-sensitive. We would need to somehow allow for MySQL/MariaDB to optionally...

Converted to a draft for now - I think I've accomplished just about everything except the ability to force the JDBC modules to deal with usernames in one form or...

@mike-jumper I'm working through the JDBC changes required to make case sensitivity configurable, and I'm getting a bit confused in some of the mapper files. For example: https://github.com/apache/guacamole-client/blob/3611be5c41b5c08d2dc224ff197274112eea0302/extensions/guacamole-auth-jdbc/modules/guacamole-auth-jdbc-postgresql/src/main/resources/org/apache/guacamole/auth/jdbc/permission/UserPermissionMapper.xml#L26-L32 The `affected_name`...

@mike-jumper @jmuehlner Appreciate any feedback you have on this most recent round of changes. I've spent some time trying to re-work the various JDBC modules to handle configurable case sensitivity...

> > The better way is to change the collation used in the queries; however, the challenge, here, is that it requires some knowledge of what collation is being used...

I suppose the other route to consider, here, is to make the JDBC changes specific to forcing the PostgreSQL module into case-insensitive mode, and not worry about the settings/options/changes that...

@myjimmy I have some concerns with these changes... * It's unclear to me _why_ removing the `pushSelection()` and `popSelection()` calls fixes the issue described in the Jira ticket? From that,...

@myjimmy Sorry, I see that you addressed many of these on the Jira ticket. You mentioned, there, that the push/pop functionality was added to support non-text clipboard contents, which Guacamole...