Dev build doesn't update encoding settings for tables and database

[mfendeksilverstripe]

Affected Version

SilverStripe 4.6-rc1

Description

It seems that dev/build doesn't update database and table encoding settings.

Steps to Reproduce

• setup a project with default encoding settings
• change the encoding setting s to the following:

SilverStripe\ORM\Connect\MySQLDatabase:
  connection_charset: utf8mb4
  connection_collation: utf8mb4_unicode_ci
  charset: utf8mb4
  collation: utf8mb4_unicode_ci

Expected result

• encoding for database, tables, fields and indexes get updated

Actual result

• encoding for fields and indexes get updated
• database and table settings do not get updated

Note that recreating database from scratch and running dev build will produce correct encoding setup for database and fields. The problem seems to be just the update.

Workaround

Run the following query manually to update encoding in your database:

ALTER TABLE <table-name> CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;