necouchman commented on PR #902: URL: https://github.com/apache/guacamole-client/pull/902#issuecomment-2040323009
> > 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 to begin with, which (I don't think) can be programmatically detected in a way that we can use. Maybe I'm wrong, and there is a way to do this?? > > You should be able to query which collations are available on a database using `SHOW COLLATION`, but yeah it sounds like there's differing collations available in various version of MySQL/MariaDB. Trying to build something that queries which is available and tries to find the best one sounds like a mess. > > So short answer no I don't know of a better way, sadly. > > This is all more of a pain than I would have ever guessed, but generally your approach looks pretty reasonable to me so far. Thanks for the feedback. Yeah, it seems like, even using the `SHOW COLLATION` option, we'd have to have some sort of look-up table that said "if collation is x, switch to y", but that means maintaining a lookup table... -- 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
