necouchman commented on PR #902: URL: https://github.com/apache/guacamole-client/pull/902#issuecomment-1646372382
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 have a couple of options: * Create or edit collation of the column in question to a case-sensitive option. The downside of this is that the schema has to either be changed or modified on-the-fly. * Use a binary option when doing the column comparison, which might have a performance hit - views on that are mixed - because it may bypass indices. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: dev-unsubscr...@guacamole.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org
