root@localhost [(none)]> SELECT * FROM INFORMATION_SCHEMA.COLLATIONS
    -> WHERE COLLATION_NAME LIKE 'uca1400_%';
+--------------------------------+--------------------+------+------------+-------------+---------+
| COLLATION_NAME                 | CHARACTER_SET_NAME | ID   | IS_DEFAULT | IS_COMPILED | SORTLEN |
+--------------------------------+--------------------+------+------------+-------------+---------+
| uca1400_ai_ci                  | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_ai_cs                  | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_as_ci                  | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_as_cs                  | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_nopad_ai_ci            | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_nopad_ai_cs            | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_nopad_as_ci            | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_nopad_as_cs            | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_icelandic_ai_ci        | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_icelandic_ai_cs        | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_icelandic_as_ci        | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_icelandic_as_cs        | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_icelandic_nopad_ai_ci  | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_icelandic_nopad_ai_cs  | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_icelandic_nopad_as_ci  | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_icelandic_nopad_as_cs  | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_latvian_ai_ci          | NULL               | NULL | NULL       | Yes         |       8 |
| uca1400_latvian_ai_cs          | NULL               | NULL | NULL       | Yes         |       8 |

This revision is now accepted and ready to land.Apr 15 2023, 07:31

Closed by commit rOPSf67468667a8b: Upgrade to MariaDB 10.11 (authored by dereckson). · Explain WhyApr 15 2023, 07:32

This revision was automatically updated to reflect the committed changes.

dereckson added a commit: rOPSf67468667a8b: Upgrade to MariaDB 10.11.

Complector

$ salt db-B-001 state.apply roles/dbserver-mysql/content
[…]
----------
          ID: dbserver_mysql_db_Nasqueron
    Function: mysql_database.present
        Name: Nasqueron
      Result: True
     Comment: Database Nasqueron is already present
              Database collate uca1400_as_ci != utf8mb4_unicode_520_ci needs to be updated
     Started: 09:34:16.780371
    Duration: 9.204 ms
     Changes:
              ----------
              collate:
                  ----------
                  before:
                      utf8mb4_unicode_520_ci
                  now:
                      utf8mb4_uca1400_as_ci
[…]