I have a Google Cloud SQL instance with a default server collation of utf8_general_ci
. I'd like to change this to utf8_unicode_ci
. How can I do this?
Before, I could go to the "old" Google Cloud SQL console and run SQL as a super-admin; I thought I could make the change this way. However, I don't see this link anywhere in the new console, and when running SQL remotely (even as root), I cannot perform super-admin changes.
I've also looked at configuring MySQL flags, but only the character set is available for modification (character_set_server
), not the collation.
Is there a way I can change the default server collation to utf8_unicode_ci
in a Google Cloud SQL instance?