mysql database: Manage "character set" and "collation"

[stephan242]

What problem are you facing?

When creating a mysql database, I'm missing a feature to specify the CHARACTER SET and the COLLATION of the database (See https://dev.mysql.com/doc/refman/8.0/en/create-database.html).

When I create a DB right now with this provider on Aurora 5.7, it is using these by default, and they are pretty much unusable to me (and probably to most):

mysql> SELECT @@character_set_database, @@collation_database;
+--------------------------+----------------------+
| @@character_set_database | @@collation_database |
+--------------------------+----------------------+
| latin1                   | latin1_swedish_ci    |
+--------------------------+----------------------+
1 row in set (0.00 sec)

How could Crossplane help solve your problem?

Could you augment the provider to manage these 2 database options?

[adrianmeca]

+1