Ory is the largest open source community in the world for cloud software application security. We maintain advanced open source security software solving authentication, authorization, access control, application network security, and delegation. Ory implements a variety of industry and best-practice standards including OAuth 2.0 / OAuth 2.1, OpenID Connect, Zero Trust Networking, Google Zanzibar Policy Framework, FIDO2 U2F, WebAuthn, TOTP, and more.

Ory Community

Hi. We’re running into database collation issues on Hydra 1.11.10 when the user accepts the consent challenge. The exact error when running it in debug mode is “Error 3988: Conversion from collation utf8mb4_general_ci into latin1_swedish_ci impossible for parameter”. It’s caused by the Japanese characters in the id_token body, our hydra database is confirmed to be in Latin collation, running on MySQL 8.0.

What’s the best way to solve this? Unsure if it’s safe to convert the tables to use utf8mb4