Details
-
Type:
Improvement
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.0.1
-
Component/s: None
-
Labels:None
Description
First, remove the database collation upgrade from the database.
Add a new page in the admin interface under Tools > Utilites
On this page there should be a button "Update to utf8mb4" with a short paragraph beside it. This paragraph should be different based on the state of the system:
- If any tables or columns are utf8mb4 and mysql >= 5.7 or mariadb >= 10.2.2 "Update the character set and collation of your database, tables, and columns to utf8mb4 to support 4 byte characters such as emojis."
- If any tables or columns are utf8mb4 and mysql < 5.7 or mariadb < 10.2.2 "Please upgrade to MySQL to 5.7+ or MariaDB to 10.2.2+ to support utf8mb4 characters such as emojis."
- Disable the button under this condition
- If all tables and columns are utf8mb4 "Database already supports utf8mb4"
- Disable the button under this condition
When the button is clicked we should do the same thing we are doing in the upgrade right now (Maybe put that code in a utility so we're not making database calls in the controller).
